Reference software list

[Daniel_B]

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

[Josip]

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]

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]

Can you please help on this

[MDahitule]

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]

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]

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.