cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
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.


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
6 REPLIES 6
Josip
Engaged Sweeper II
Daniel.B wrote:
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.


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?
Josip
Engaged Sweeper II
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'




😄
MDahitule
Engaged Sweeper II
Can you please help on this
MDahitule
Engaged Sweeper II
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.
Daniel_B
Lansweeper Alumni
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.
Sdonovan415
Engaged Sweeper II
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.