![]() ![]() ![]() I have written a stored procedure that resolves this problem but I am only able to run it via SSMS console, as the code for the stored procedure does not run from lansweeper either due to creation of temporary tables etc. 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 All data will be removed on September 25, 2020. Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID A360 Desktop June 19, 2018: Autodesk Desktop Connector: A360 Desktop Retirement - June 19th, 2018 What will replace A360 Desktop after its retirement A360 Drive: May 2020: September 25, 2020: Autodesk Drive: Starting March 25, 2020, A360 Drive files will be read-only. 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. ![]()
0 Comments
Leave a Reply. |