Notification

Icon
Error

Reference software list - Displays list of software on reference computer and computers missing any of the installations

Posted: Monday, February 23, 2015 1:50:26 PM(UTC)
Daniel.B

Daniel.B

Member Original PosterPosts: 1,150
1
Like
This report will list all software installations on a reference computer called "Reference" (i.e. lab computer) in the example below. Next to each software a list of workstations will be displayed not having this software installed.

Code:

Select Top 1000000 tblSoftwareUni.softwareName,
  tNotInstalled.AssetID,
  tNotInstalled.AssetName
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
  Left Join (Select tblSoftwareUni.SoftID,
    tblAssets.AssetID,
    tblAssets.AssetName
  From tblSoftwareUni,
    tblAssets
    Inner Join tblComputersystem
      On tblAssets.AssetID = tblComputersystem.AssetID
  Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
    Not Exists(Select tblSoftware.softID,
      tblSoftware.AssetID From tblSoftware
    Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
      tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
    tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
  tNotInstalled.AssetName
Sdonovan415
#1Sdonovan415 Member Posts: 5  
posted: 3/9/2015 5:16:57 PM(UTC)
What about if you want a list of all Installed software and OS on every asset? I am learning SQL and any help will be greatly appreciated.
Daniel.B
#2Daniel.B Member Original PosterPosts: 1,150  
posted: 3/10/2015 2:44:27 PM(UTC)
Your question was answered in this forum topic. The report here is complex to calculate. It compares software installations on a reference computer with those on other computers in the network.
MDahitule
#3MDahitule Member Posts: 9  
posted: 7/5/2017 2:59:32 PM(UTC)
Hi Daniel

I need to create a report which provide software installed other than reference computer. i.e. Software difference between reference and target computer.

Can you please help

Thanks in advance.
MDahitule
#4MDahitule Member Posts: 9  
posted: 7/12/2017 8:04:25 AM(UTC)
Can you please help on this
DeviantTomato
#5DeviantTomato Member Posts: 11  
posted: 2/23/2021 1:02:12 PM(UTC)
MDahitule




you already can do that with tis script too.
Just instead of 'Reference' put your asset and run the script.
You will get a list of all devices on your network that and programs that dont corelate with tkhe 'Reference' device.
Now all you have to do is search for your asset in 'Asset name'




:D
DeviantTomato
#6DeviantTomato Member Posts: 11  
posted: 2/23/2021 1:16:48 PM(UTC)
Originally Posted by: Daniel.B Go to Quoted Post
This report will list all software installations on a reference computer called "Reference" (i.e. lab computer) in the example below. Next to each software a list of workstations will be displayed not having this software installed.

Code:

Select Top 1000000 tblSoftwareUni.softwareName,
  tNotInstalled.AssetID,
  tNotInstalled.AssetName
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
  Left Join (Select tblSoftwareUni.SoftID,
    tblAssets.AssetID,
    tblAssets.AssetName
  From tblSoftwareUni,
    tblAssets
    Inner Join tblComputersystem
      On tblAssets.AssetID = tblComputersystem.AssetID
  Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
    Not Exists(Select tblSoftware.softID,
      tblSoftware.AssetID From tblSoftware
    Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
      tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
    tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
  tNotInstalled.AssetName













Hey Daniel,



do you know of a way to reference 2 devices(computers) and compare softwares and stating the rule

that would enable automatic deployment of programs in question?/




We are now in a process of replacing 200 old computers with the new ones ,but each user wants to have softwares specific to their tasks pre installed on new computers.

As you can imagine it's a tedious task of comparing old and new comp and installing those software.

I am looking for a way to automate that to some level.


Any suggestions?

Active Discussions

Lansweeper Layer 3 network devices only report
by  dri   Go to last post Go to first unread
Last post: 9/22/2021 6:24:05 PM(UTC)
Lansweeper VMware vCenter Server File Upload Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: 9/22/2021 4:18:21 PM(UTC)
Lansweeper Windows Thin PC EOL
by  Esben.D  
Go to last post Go to first unread
Last post: 9/21/2021 1:30:44 PM(UTC)
Lansweeper History of relationship between pc and monitor
by  hfaddy  
Go to last post Go to first unread
Last post: 9/17/2021 1:44:38 PM(UTC)
Lansweeper New Hire Login Request Report
by  Scott Davis   Go to last post Go to first unread
Last post: 9/16/2021 7:16:46 PM(UTC)
Lansweeper SCCM end of life
by  Esben.D  
Go to last post Go to first unread
Last post: 9/16/2021 2:56:23 PM(UTC)