To find specific software on assets please use the report below. Change “ENTER SOFTWARE NAME HERE” to the name of the specific software.
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblAssets.Lasttried, tblSoftwareUni.softwareName From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Left Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Left Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Where tblSoftwareUni.softwareName = 'INSERT SOFTWARE NAME HERE' And tblAssetCustom.State = 1
To use the report above, do the following: •Open the report builder under Reports/Create New Report. •Paste the SQL query we provided at the bottom of the page. •Left-click somewhere in the upper section of the page so the query applies. •Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
To find specific software on assets please use the report below. Change “ENTER SOFTWARE NAME HERE” to the name of the specific software.
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblAssets.Lasttried, tblSoftwareUni.softwareName From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Left Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Left Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Where tblSoftwareUni.softwareName = 'INSERT SOFTWARE NAME HERE' And tblAssetCustom.State = 1
To use the report above, do the following: •Open the report builder under Reports/Create New Report. •Paste the SQL query we provided at the bottom of the page. •Left-click somewhere in the upper section of the page so the query applies. •Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.