Software Scan by IP location

[chads]

is it possible to build a "all software report based on IP location" ?

[Srikanth08]

Here where i can mention my IP location..it is showing overall

[Hemoco]

Srikanth08 wrote:
Here where i can mention my IP location..it is showing overall

Could you clarify this question, perhaps with screenshots?
If you do not see any entries under IP location, that means no IP locations have been configured in the configuration console under Configuration\IP Range Locations.

[Srikanth08]

Thanks..but is it possible to group the software details by computer unique..because it is showing as individual record..

[Hemoco]

Srikanth08 wrote:
Thanks..but is it possible to group the software details by computer unique..because it is showing as individual record..

Could you clarify what you mean by "individual record"?

The first report posted sorted by IP location and then ComputerUnique. To sort by ComputerUnique, use the following report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName As Software,
tblSoftware.softwareVersion As Version, tblSoftware.SoftwarePublisher As
Publisher, Count(tblSoftware.ComputerName) As Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Order By tblComputers.ComputerUnique

[chads]

Perfect thank you.

[Hemoco]

Use the following report for a software overview that includes computer name and IP location:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName As Software,
tblSoftware.softwareVersion As Version, tblSoftware.SoftwarePublisher As
Publisher, Count(tblSoftware.ComputerName) As Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Order By web40AllIPLocations.IPLocation, tblComputers.ComputerUnique,
Count(tblSoftware.ComputerName) Desc

Replace "Your Location" in the report below to filter out a specific IP location:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName As Software,
tblSoftware.softwareVersion As Version, tblSoftware.SoftwarePublisher As
Publisher, Count(tblSoftware.ComputerName) As Total
From tblSoftware Inner Join
tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
web40AllIPLocations.IPLocation, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Having web40AllIPLocations.IPLocation = 'Your Location'
Order By web40AllIPLocations.IPLocation, tblComputers.ComputerUnique,
Count(tblSoftware.ComputerName) Desc