hey Team, i am trying to build a query to fetch the loggin profiles/accounts on the hosts so for mac can i get some help how to fetch the loggin apple id?

Here you go:

SELECT key, subkey, value FROM plist WHERE path LIKE '/Users/%%/Library/Preferences/MobileMeAccounts.plist' AND subkey like 'AccountDescription';