Never mind I found the query on another page of the site.
http://www.techygeekshome.co.uk/2014/04/create-ssrs-report-using-configuration.html
SELECT
SYS.Netbios_Name0 AS [Computer Name],
USR.Manufacturer0 AS [Make],
USR.Model0 AS [Model],
BIO.SerialNumber0 AS [Asset Tag],
CAD.KeyName00 AS [Product ID],
CAD.ProductName00 AS [AutoCAD Suite],
CAD.Release00 AS [AutoCAD Version],
CAD.SerialNumber00 AS [AutoCAD Serial Number],
CAD.TimeKey AS [Last Inventory]
FROM
AUTODESK_INVENTORY_DATA CAD
INNER JOIN v_R_System SYS
ON SYS.ResourceID = CAD.MachineID
INNER JOIN V_GS_COMPUTER_SYSTEM USR
ON SYS.ResourceID = USR.ResourceID
INNER JOIN v_GS_PC_BIOS BIO
ON SYS.ResourceID = BIO.ResourceID
WHERE ProductName00 IS NOT NULL
ORDER BY "AutoCAD Suite"
From: [email protected] [mailto:[email protected]] On
Behalf Of Feret, Greg
Sent: Monday, June 22, 2015 12:14 PM
To: [email protected]
Subject: [mssms] Inventory for Autodesk products
I am trying to get inventory on our Autodesk products in the enterprise
following
http://www.techygeekshome.co.uk/2012/08/step-by-step-guide-to-reporting-autocad.html
I have the MOF and DCM in place but the link to the report file is broken.
I was wondering if anyone would be able to assist with a report for these
products?
Thanks in advace,
Greg
The information contained in this email message may be privileged,
confidential, and protected from disclosure. Any unauthorized use,
printing, copying,disclosure, dissemination of or reliance upon
this communication by persons other than the intended recipient
may be subject to legal restriction or sanction. If you think that
you have received this E-mail message in error, please reply to
the sender and delete this email promptly.
The information contained in this email message may be privileged,
confidential, and protected from disclosure. Any unauthorized use,
printing, copying,disclosure, dissemination of or reliance upon
this communication by persons other than the intended recipient
may be subject to legal restriction or sanction. If you think that
you have received this E-mail message in error, please reply to
the sender and delete this email promptly.
