cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Rob-CD
Engaged Sweeper II
Hi All,

Please would I be able to ask for assistance if anyone has ever built a report to show all or certain Java instances that are installed across all assets previously scanned by Lansweeper?

I can easily search for a Java instance with the main search option, and then export that information out into Excel.

However what I need it the same information from doing the above, but with the additional field of OU showing as well?

This would really help the internal team who are after this information decipher which devices are staff devices and which are student devices.

Any help would be very much appreciated.

Many thanks,

Rob Crossland-Diskin (by no means an SQL report building expert!)
8 REPLIES 8
Rob-CD
Engaged Sweeper II
That definitely does, as good to know where the Computer OU option is as I couldn't firstly find it anywhere.

Many thanks again for your help,

Rob
Rob-CD
Engaged Sweeper II
Awesome thanks for that! Works perfectly and is just what I was after
Rob-CD wrote:
Awesome thanks for that! Works perfectly and is just what I was after


Hopefully this helps.

CyberCitizen
Honored Sweeper
Try This...

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblADComputers.OU
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
Rob-CD
Engaged Sweeper II
Hi,

It's the Computer OU that's I'm wanted the report to also pull through if you able to provide a line of relevant code to add in for the report to show this?

Below is currently how the report script looks:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
CyberCitizen
Honored Sweeper
Which OU are you wanting to capture? Computer OU or User OU?
Rob-CD
Engaged Sweeper II
Hi Esben,

Thanks for the link.

I've ran it and changed the wording to 'Java' but this report still doesn't pull of the OU column that I would like to include in the report if any advise on how to add this in?

Many thanks,

Rob Crossland-Diskin (by no means an SQL report building expert!)
Esben_D
Lansweeper Employee
Lansweeper Employee
This should help: https://www.lansweeper.com/report/specific-software-installed-audit/