Notification

Icon
Error

List of all servers with flag for specific softwre

Posted: Tuesday, May 3, 2022 7:38:26 PM(UTC)
malbanese@stamfordct.gov

malbanese@stamfordct.gov

Member Original PosterPosts: 19
0
Like
This issue has been solved! Click here to view the solution
I am trying to create a report that will show all of the servers on my domain and add a Yes/No field to show the presence of a specific software package from Add/Remove list. I can get a list of only the servers with the software, but I want to see what the total percentage of installation is.

I am working on a software deployment project and I want to make sure that I cover all of the servers.

Thank you!
Andy.S
#1Andy.S Member Posts: 159  
posted: 5/6/2022 7:38:40 AM(UTC)
Here is an example of a report to display all Servers, with Yes No columns for 3 types of software :

Code:
Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  Case
    When Software1.AssetID Is Not Null Then 'Yes'
    Else 'No'
  End As 'Software1',
  Case
    When Software2.AssetID Is Not Null Then 'Yes'
    Else 'No'
  End As 'Software2',
  Case
    When Software3.AssetID Is Not Null Then 'Yes'
    Else 'No'
  End As 'Software3'
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Left Join (Select tblSoftware.softwareVersion,
      tblSoftwareUni.softwareName,
      tblSoftware.AssetID
    From lansweeperdb.dbo.tblSoftware
      Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
    Where tblSoftwareUni.softwareName Like '%Software1%') Software1 On
      Software1.AssetID = tblassets.AssetID
  Left Join (Select tblSoftwareUni.softwareName,
      tblSoftware.softwareVersion,
      tblSoftware.AssetID
    From lansweeperdb.dbo.tblSoftware
      Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
    Where tblSoftwareUni.softwareName Like '%Software3%') Software3 On
      Software3.AssetID = tblassets.AssetID
  Left Join (Select tblSoftware.AssetID,
      tblSoftwareUni.softwareName,
      tblSoftware.softwareVersion
    From lansweeperdb.dbo.tblSoftware
      Inner Join lansweeperdb.dbo.tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
    Where tblSoftwareUni.softwareName Like '%Software2%') Software2 On
      Software2.AssetID = tblassets.AssetID
  Inner Join lansweeperdb.dbo.tblComputersystem On tblassets.AssetID =
      tblComputersystem.AssetID
Where tsysassettypes.AssetTypename Like 'Windows' And
  tblComputersystem.Domainrole > 1 And tblassetcustom.State = 1


malbanese@stamfordct.gov
#2malbanese@stamfordct.gov Member Original PosterPosts: 19  
posted: 5/11/2022 8:20:19 PM(UTC)
Thank you, this worked perfectly

Active Discussions

Lansweeper Lansweeper Dark Theme
by  mrobbins   Go to last post Go to first unread
Last post: Yesterday at 5:38:01 PM(UTC)
Lansweeper Detect Docking Stations
by  GlenH  
Go to last post Go to first unread
Last post: Yesterday at 3:52:13 PM(UTC)
Lansweeper Exclude non-windows assets from scanning by assetname
by  rapheren   Go to last post Go to first unread
Last post: Yesterday at 1:18:12 PM(UTC)
Lansweeper HTTPS Certifikate untrusted
by  pskup  
Go to last post Go to first unread
Last post: Yesterday at 9:20:07 AM(UTC)
Lansweeper Migrate to new host but without SQL
by  pskup   Go to last post Go to first unread
Last post: Yesterday at 9:03:14 AM(UTC)
Lansweeper Object reference error after updating to 10.2.0.0
by  Erik.T  
Go to last post Go to first unread
Last post: Yesterday at 8:10:25 AM(UTC)
Lansweeper Custom reporting - Asset Groups and AD Description
by  rbshawn   Go to last post Go to first unread
Last post: 6/29/2022 10:54:10 PM(UTC)
Lansweeper A FIX for an odd Scan Error WMI/DCOM from scanning server
by  danielm  
Go to last post Go to first unread
Last post: 6/29/2022 10:14:44 PM(UTC)