Show All Local Groups On Device
Query
// Use Case: Show all locally available User Groups including Privileged Groups
LocalGroupExplanation
This query is designed to retrieve and display all user groups that are locally available on a system, including those that have elevated privileges. The LocalGroup table or dataset is being queried to list these groups. Essentially, it's a way to see all the user groups on a local machine, with a focus on identifying any groups that have special or administrative permissions.
Details
Ugur Koc
Released: December 13, 2024
Tables
LocalGroup
Keywords
LocalGroupUserGroupsPrivileged
Operators
projectwheresummarizecountjoindistinctorder bylimittaketopextendparseparse_jsonparse_csvparse_xmlparse_urlparse_urlqueryparse_urlquerystringparse_urlpathparse_urlpath_and_queryparse_urlpath_and_querystringparse_urlpath_and_querystring_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_portparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_schemeparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragmentparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_queryparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfoparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_hostparse_urlpath_and_querystring_and_fragment_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port_and_scheme_and_fragment_and_query_and_userinfo_and_host_and_port