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 Sync information
by  prighi61   Go to last post Go to first unread
Last post: Yesterday at 2:34:06 PM(UTC)
Lansweeper Deleting, removing or hiding default ticket states
by  prighi61  
Go to last post Go to first unread
Last post: Yesterday at 1:16:52 PM(UTC)
Lansweeper Switch Dell S4128 Scan error
by  matteor   Go to last post Go to first unread
Last post: Yesterday at 1:04:03 PM(UTC)
Lansweeper Patch Tuesday report showing wrong results
by  NoZart  
Go to last post Go to first unread
Last post: Yesterday at 11:44:58 AM(UTC)
Lansweeper How do I create a new ticket using the API?
by  prighi61   Go to last post Go to first unread
Last post: Yesterday at 9:36:39 AM(UTC)
Lansweeper IP Location "undefined"
by  Kboyer  
Go to last post Go to first unread
Last post: 9/23/2021 9:25:46 PM(UTC)
Lansweeper Modify root cause list
by  Arno Butter   Go to last post Go to first unread
Last post: 9/23/2021 8:38:25 PM(UTC)
Lansweeper scanning network devices
by  mattscratt  
Go to last post Go to first unread
Last post: 9/23/2021 8:04:43 PM(UTC)