Report to get the local accounts and Groups on computers

Products

• IT Management Suite

Issue/Introduction

You need to gather data from Inventory Solutions and Basic Inventory tables to create a report on the local accounts (the group "Users") 

 

Environment

ITMS 8.x

Resolution

Following query gathers data from Inventory Solution SQL tables as well as from Basic Inventory SQL tables of managed clients (report includes only managed computers where Symantec Management Agent is installed).

SELECT DISTINCTvi.Guid,
vi.Name AS [PC Name],
iugua.[User Name],
iugua.[User ID],
iugua.[Full Name],
iaapu.[User] AS [Primary User],
iugua.[Domain] AS [Domain Name],
iug.[Name] AS [User Group Name],
iugua.[Primary Group ID],
iaai.[Last Logon User]
FROM vComputer vi
JOIN Inv_UG_User_Account iugua
ON iugua._ResourceGuid = vi.Guid
JOIN Inv_UG_Group iug
ON iug._ResourceGuid = vi.Guid
JOIN Inv_AeX_AC_Primary_User iaapu
ON iaapu._ResourceGuid = vi.Guid
JOIN Inv_AeX_AC_Identification iaai
ON iaai._ResourceGuid = vi.Guid
ORDER BY [PC Name]
ASC

 

Note!

There will be a lot of records returned by this Query, because it shows each User Group per User.

If you don't want to see user groups, then remove this from Query

• iug.[Name] AS [User Group Name],
• iugua.[Primary Group ID],