‎10-26-2023
05:53 PM
- last edited on
‎04-02-2024
11:01 AM
by
Mercedes_O
Good morning,
I need to run an export of all the software installed on a given company ( which has no domain but I have it broken down by IP address ), breaking them down by client so that at the end as a result comes out the name of the client and all the software it has installed.
Or the other way around, that is, the software installed in that particular company in which clients is installed?
How can I do that?
Thank you.
‎11-06-2023 01:59 PM
Hello @ErikT,
I tried but it shows me "This report has no results".
I have already created the asset location and changed it in the query you sent me.
What else can I try to help you?
Thank you
‎11-03-2023 09:55 AM
In the Configuration > Asset Groups tab you should first create different IP locations for the given companies. Afterwards, you can run the below report to show all software installed on the asset in that IP location.
Note that you'll need to create a report for each IP location you have created. Change the <IP location name> for each report.
Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
(Select Case tblSoftware.MsStore
When 0 Then 'Desktop app'
Else 'Microsoft Store app'
End) As 'Type',
tblSoftwareUni.SoftwarePublisher As Publisher,
Count(tblSoftware.AssetID) As Total,
tsysIPLocations.IPLocation As [IP Location Name]
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
Left Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Where tsysIPLocations.IPLocation = '<IP location name>' And
tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.MsStore,
tsysIPLocations.IPLocation
Order By Total Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now