→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bwbjr
Engaged Sweeper
Looking to make a report that will tell me the asset name, autodesk product installed and if its a network version, standalone version or Multi seat standalone


thanks
2 REPLIES 2
bwbjr
Engaged Sweeper
I have a report that can do that, the bigger issues is needing to know if its network or standalone install
Nick_VDB
Champion Sweeper III
We added an example report below that will give back the autodesk software installation on your machines. It is however not possible to say if the version is network, standalone or multi seat. You can follow the instruction here on how to run a report.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.SoftwarePublisher Like '%autodesk%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
Software