Results in only 40 Detected PC's and 5 Autodesk products, while we own 98 Licenses and about 15 diffrent Autodesk products and have about ~120 pc's as some of our owned licenses are network based licenses. Where tblSerialnumber.Product Like 'Autocad%' And tblAssetCustom.State = 1 Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

The query above at least finds all the various products albeit many duplicates. Where tblSoftwareUni.SoftwarePublisher Like 'Auto%'Ī360 Desktop Bmsit0002 HerselmanG Autodesk 1143-4007-4388-8635-8450-4419Ī360 Desktop Bmsit0002 HerselmanG Autodesk GYJRG-NMYMF-VGBM4-T3QD4-842DWĪ360 Desktop Bmsit0002 HerselmanG Autodesk NPPR9-FWDCX-D2C8J-H872K-2YT43Ī360 Desktop Bmsit0002 HerselmanG Autodesk PD3PC-RHNGV-FXJ29-8JK7D-RJRJKĪ360 Desktop Bmsit0002 HerselmanG Autodesk XQNVK-8JYDB-WJ9W3-YJ8YR-WFG99Īs you can see due to the wrong asset ID being extracted I cannot use destinct to get a single entry for example A360 Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Select Distinct Top 1000000 tblSoftwareUni.softwareName, I am trying to pull a report of all Auto desk products installed. Is there a way to run a stored procedure when using SQL datanase to return a report.

A360desktop