
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2015 01:50 PM
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
Labels:
- Labels:
-
Finished Reports
-
Report Center
6 REPLIES 6

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2021 01:16 PM
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?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2021 01:02 PM
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'
😄
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'
😄

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2017 09:04 AM
Can you please help on this

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-05-2017 03:59 PM
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.
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2015 02:44 PM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2015 05:16 PM
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.
