cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mmullen
Engaged Sweeper
Hello,

What is the best way to export a list of all software installed on a machine basis? IE everything installed on machine A and everything installed on machine B?

Within the Software screen I see that you can drill down into lists of all machines that have say Microsoft Silverlight.
5 REPLIES 5
nnewton
Engaged Sweeper III
This is what we use:

SELECT TOP 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 AS icon,
tblAssets.AssetName,
tblSoftwareUni.softwareName AS Software,
tblSoftwareUni.SoftwarePublisher AS Publisher,
tblSoftware.softwareVersion AS Version,
tblAssets.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Displayname,
tblADusers.Title,
tblADusers.Department AS Division,
tblADusers.Division AS Department,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSoftware.Installdate,
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblOperatingsystem.Version AS OSVersion
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
LEFT JOIN tblADusers ON tblAssets.Username = tblADusers.Username
LEFT OUTER JOIN tblSystemEnclosure ON tblAssets.AssetID = tblSystemEnclosure.AssetID
LEFT OUTER JOIN TsysChassisTypes ON tblSystemEnclosure.ChassisTypes = TsysChassisTypes.Chassistype
LEFT JOIN tblOperatingsystem ON tblAssets.AssetID = tblOperatingsystem.AssetID
WHERE tblAssetCustom.State = 1;
Andy_Sismey
Champion Sweeper III
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
RCorbeil
Honored Sweeper II
Create a report of your assets and add tblSoftware and tblSoftwareUni to it.
mmullen
Engaged Sweeper
That does work. Is there a way to export the list for all assets?
Andy_Sismey
Champion Sweeper III
Hi,

Not sure if this is what your after but if you go into an asset and select "Software" you will see a list of installed software, on the right you will see the export buttons for excel, is this what your after (see attached) ?