→ 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: 
estuardohbo
Engaged Sweeper
I need support to find all installed programs on every PC that belongs to a specific network

For example: 10.x.x.1 to 10.x.x.254
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
A sample report that lists software installed on computers within 10.41.0.1 - 10.41.0.254 can be seen below. Use the numeric IP format in your criteria. To convert from text to numeric:
• Remove the periods. You’ll be left with 4 sets of digits.
10.41.0.1 -> 10 41 0 1
• Add zeros to the last 3 sets of digits, so each set has 3 digits.
10 41 0 1 -> 10 041 000 001
• Remove any spaces.
10 041 000 001 -> 10041000001

To use the sample report provided, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
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
Where tblAssetCustom.State = 1 And tblAssets.IPNumeric Between 10041000001 And
10041000254

Order By tblAssets.AssetName,
software,
version

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
A sample report that lists software installed on computers within 10.41.0.1 - 10.41.0.254 can be seen below. Use the numeric IP format in your criteria. To convert from text to numeric:
• Remove the periods. You’ll be left with 4 sets of digits.
10.41.0.1 -> 10 41 0 1
• Add zeros to the last 3 sets of digits, so each set has 3 digits.
10 41 0 1 -> 10 041 000 001
• Remove any spaces.
10 041 000 001 -> 10041000001

To use the sample report provided, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
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
Where tblAssetCustom.State = 1 And tblAssets.IPNumeric Between 10041000001 And
10041000254

Order By tblAssets.AssetName,
software,
version
Lansweeper wrote:
A sample report that lists software installed on computers within 10.41.0.1 - 10.41.0.254 can be seen below. Use the numeric IP format in your criteria. To convert from text to numeric:
• Remove the periods. You’ll be left with 4 sets of digits.
10.41.0.1 -> 10 41 0 1
• Add zeros to the last 3 sets of digits, so each set has 3 digits.
10 41 0 1 -> 10 041 000 001
• Remove any spaces.
10 041 000 001 -> 10041000001


To use the sample report provided, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.
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
Where tblAssetCustom.State = 1 And tblAssets.IPNumeric Between 10041000001 And 10041000254
Order By tblAssets.AssetName,
software,
version






thanks for the help