Computer Model to User Report
Updated: 07 Jul 2009 | 3 comments
The attached file creates an asset report for computer model to user and includes the serial number
download Filed Under:
The attached file creates an asset report for computer model to user and includes the serial number
Comments
Trouble with the SQL
Do I put this in report builder or use the SQL to build a collection?
Download the file. Rename
Download the file. Rename the extension from "txt" to "xml". From the NS 6.0 console, select the report tab, right click the left pane and select import.
Steve Petrasek
Adjustment
Thanks for this report!
I made two adjustments to make it work at my site.
First thing was to add DISTINCT so serialnumber, second was to add '%Computer Model%' to the where statment. Full SQL-statement:
SELECT DISTINCT T1.[Serial Number] AS 'Serial Number', T1.[Computer Model] AS 'Computer Model', T0.[User] AS 'User'
FROM [Inv_AeX_AC_Primary_User] T0 INNER JOIN [Inv_AeX_HW_Serial_Number] T1 ON T0.[_ResourceGuid] = T1.[_ResourceGuid]
WHERE T1.[Computer Model] LIKE '%Computer Model%'
Would you like to reply?
Login or Register to post your comment.