→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nico_Uk
Engaged Sweeper

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.

2 REPLIES 2
Nico_Uk
Engaged Sweeper

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

ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@Nico_Uk 

 

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