Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2014 07:38 PM
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
For example: 10.x.x.1 to 10.x.x.254
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2014 08:09 PM
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.
• 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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2014 08:09 PM
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.
• 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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-10-2014 10:59 PM
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