Need report to show all users with no assets assigned

fakenb's picture

Help.  I know very little about Reports.  I need to create a report that will give me a list of all users without computer assets assigned to them.  Or users with or without assets assigned.  Has anyone ever created such a report?

Brenda

LeslieMiller's picture

Brenda-- What Symantec

Brenda--
What Symantec product are you using? That will hep me classify your question to try and get you a better answer.

fakenb's picture

I was told it should be

I was told it should be classified as Asset/CMDB.  We are at the 6.x version of everything and pretty much have the total management suite (CMS1-3, SMS 1-3, Workflow).  I don't know enough about it so I had to ask our network staff what we have.  Any help would be appreciated.

MBHarmon's picture

YMMV

You'll need to modify this report, but here's what I have so far for you:
 

SELECT DISTINCT gd1.[Display Name] AS 'Owner',
 gd1.[Department],
 gd1.[Office Location] AS 'Location',
 gd1.[Office Telephone] as 'Phone',
 gd1.[_ResourceGuid]
FROM [Inv_Global_User_General_Details] gd1
WHERE gd1.[_ResourceGuid] NOT IN (
 Select gd2.[_ResourceGuid]
 From [Inv_Global_User_General_Details] gd2
 INNER JOIN [ResourceAssociation] ra ON gd2.[_ResourceGuid] = ra.[ChildResourceGuid]
 WHERE ra.[ResourceAssociationTypeGuid] = '96b675a0-6f8c-4736-bf39-45d45d298478')
 
Order by gd1.[Department]

Now some things will need to change based off your environment.  Specifically the Resource Association Type Guid will need to be different because you may be using a different user to Device guid than I am. 
Also You may need to change the [ChildResourceGuid] to say [ParentResourceGuid] if your users are the Parents in the association. 

You can find all of this information on your configuration tab if you search for the association name.    Let me know if you need any help.

I'll have to let Leslie move this since I can't seem to find how to do that. 

- Matt