If I could get the domain to report, that would make this report a lot more usable because we have tons of different IP locations in our offices.įrom your explanation, I gather that you simply want the name of the asset and a count of the total number of software on the machine. Inner Join tblSoftwareUni On tblMacApplications.softid = tblSoftwareUni.SoftID On tblAssets.AssetID = tblMacApplications.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID Inner Join tsysIPLocations On tsysIPLocations.LocationID = Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID TblSoftwareUni.SoftwarePublisher As Publisher, Select Top 1000000 tblSoftwareUni.softwareName As Software, We have a few different domains and I can only seem to get the IP Location to work, here is my code. I am trying to get a count of software on all computers by domain.
0 Comments
Leave a Reply. |