Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Need report to show all users with no assets assigned

Updated: 22 May 2010 | 3 comments
fakenb's picture
0 0 Votes
Login to vote

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

Comments

LeslieMiller's picture
09
Nov
2009
0 Votes 0
Login to vote

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
09
Nov
2009
0 Votes 0
Login to vote

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
09
Nov
2009
0 Votes 0
Login to vote

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