Notification

Icon
Error

Software List by Computer/Server Name - How can you export a list by computer or server name of all the software installed on that machine?

Posted: Friday, July 31, 2020 9:57:09 PM(UTC)
SB Mike

SB Mike

Member Original PosterPosts: 2
0
Like
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.
Andy.S
#1Andy.S Member Posts: 27  
posted: 8/5/2020 3:38:09 PM(UTC)
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) ?
Andy.S attached the following image(s):
Export Software.PNG
SB Mike
#2SB Mike Member Original PosterPosts: 2  
posted: 8/5/2020 3:47:53 PM(UTC)
That does work. Is there a way to export the list for all assets?
RC62N
#3RC62N Member Posts: 455  
posted: 8/5/2020 5:44:16 PM(UTC)
Create a report of your assets and add tblSoftware and tblSoftwareUni to it.
Andy.S
#4Andy.S Member Posts: 27  
posted: 8/6/2020 8:06:43 AM(UTC)
Code:
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
nnewton
#5nnewton Member Posts: 20  
posted: 8/7/2020 6:56:47 AM(UTC)
This is what we use:
Code:

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;

Active Discussions

Lansweeper Email to close ticket
by  wgonzalez_hope   Go to last post Go to first unread
Last post: Yesterday at 3:54:01 PM(UTC)
Lansweeper Mass update assets through csv
by  B.L.  
Go to last post Go to first unread
Last post: Yesterday at 3:30:21 PM(UTC)
Lansweeper Restrict the access to the knowledgebase
by  ABEAL   Go to last post Go to first unread
Last post: Yesterday at 1:38:25 PM(UTC)
Lansweeper Wake on Lan Issues
by  Christophe  
Go to last post Go to first unread
Last post: Yesterday at 1:09:12 PM(UTC)
Lansweeper Reason: No email address found for the following user
by  Juha Otava   Go to last post Go to first unread
Last post: Yesterday at 9:59:41 AM(UTC)
Lansweeper Windows 10 Upgrade to 2004
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 8:47:16 AM(UTC)
Lansweeper Scanning despite exclusion
by  pskup   Go to last post Go to first unread
Last post: Yesterday at 7:27:08 AM(UTC)
Lansweeper Export ticket to CSV
by  KeithBecker  
Go to last post Go to first unread
Last post: 8/13/2020 5:56:10 PM(UTC)