Video Screencast Help

List All Computer Resources / Asset and owner

Created: 12 Apr 2013 | 1 comment

How can I run a report that list all Computer Resources Asset and the Owner. 

 

I have this, but all I ma getting is a Guid.  I need an actual usable name...

 

DECLARE @v1_TrusteeScope nvarchar(155)
   SET @v1_TrusteeScope = N'{2E1F478A-4986-4223-9D1E-B5920A63AB41},{582029E2-FC5B-4717-8808-B80D6EF0FD67},{B760E9A9-E4DB-404C-A93F-AEA51754AA4F},{ED6E7E4B-4DF3-45A9-AB8E-D28371144C24}'
SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca4_AeX AC Identification].[Hardware Serial Number],
   [dca4_AeX AC Identification].[Name] AS [Name1],
   [dca3_Ownership Details].[Owner]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_Ownership_Details] AS [dca3_Ownership Details]
         ON ([vri2_Computer].[Guid] = [dca3_Ownership Details].[_ResourceGuid])
      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])
WHERE
   (
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
 

Operating Systems:

Comments 1 CommentJump to latest comment

luke.s's picture

 

Hi The_yeti,
 
In the above posted query you´re searching computer name twice and both are in a red section:
CompName.png
 
So if you need the computer name, your query is already bringing this information. Could you please  provide more details about the info you're needing add in this query?
 
Regards,
 
Fábio Sanches

If the suggestion has helped to solve your problem, please mark the post as a solution.

Fábio Sanches
IT Technical Manager | WTR Services | www.wtrservices.com.br