Missing Licenses

[techieanalyst]

I noticed that Exchange and Lync licenses are not being picked up

also is there any possible way to just run a report that tells me what licenses are on what machines etc?

[Hemoco]

techieanalyst wrote:
Not seeing xen listed?

Our report lists assets whose asset type is "Xen Server". Please verify what your assets' asset types are.

techieanalyst wrote:
What about a report that just shows the following

VMware host cores aren't scanned. For the rest of the information you are after, try the sample (VMware) report below. (Please don't submit duplicate posts. We reply to each thread as quickly as possible.)

Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName As GuestName,
tblAssets1.Domain As GuestDomain,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblAssets1.NrProcessors As GuestNrProcessors,
tblProcessor.NumberOfCores As GuestCoresPerProcessor,
tblSerialnumber.Product,
Count(tblSerialnumber.SerialID) As KeyCount
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Inner Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblVmwareGuestNetwork.MacAddress
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Left Join tblSerialnumber On tblAssets1.AssetID = tblSerialnumber.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Left Join tblProcessor On tblAssets1.AssetID = tblProcessor.AssetID
Where tblAssetCustom.State = 1
Group By tsysAssetTypes.AssetTypeIcon10,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName,
tblAssets1.Domain,
tsysAssetTypes1.AssetTypename,
tblAssets1.IPAddress,
tblAssets1.NrProcessors,
tblProcessor.NumberOfCores,
tblSerialnumber.Product
Order By tblAssets.AssetName,
GuestName,
tblSerialnumber.Product

[Hemoco]

- We do not currently have a release date for Lansweeper 5.1, but we hope to release a beta installer by the end of September.
- There is no "publisher" field for product keys. You would have to manually filter the product names to only report on Microsoft products.
- SQL Server: only searches for SQL Server 2005 and SQL Server 8.0 product keys are built-in. A list of supported keys can be found under Configuration/License Compliance/Product Keys. You can add registry locations to this list as well.
- A sample report that lists Xen, VMware and Hyper-V servers can be seen below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where ((tsysAssetTypes.AssetTypename = 'xen server' Or
tsysAssetTypes.AssetTypename = 'vmware server') And tblAssetCustom.State =
1) Or
(tblAssets.AssetID In (Select tblHyperVGuest.AssetID
From tblHyperVGuest) And tsysAssetTypes.AssetTypename = 'windows' And
tblAssetCustom.State = 1)

[techieanalyst]

Mind giving me a query that just looks for the hosts?

Anything that's Xen Server, VMware or Hyper-V? Not one that lists the VMs under each?

[techieanalyst]

When is 5.1 due?

Also how do I make it so licenses from other companies show up, only interested in MS Products?

SQL licenses don't seem to appear either, but it can detect the different versions under the SQL Server report

What I would like is a report that shows all the MS Licenses including SQL etc

[techieanalyst]

Is there a way I can manually assocate a VM with a Host for the xen side? Seems like it would be possible, maybe a customer query or a table edit?

[Hemoco]

techieanalyst wrote:
Is there a way I can manually assocate a VM with a Host for the xen side?

Not currently, no. This feature will be included in Lansweeper 5.1. Note that we do not support making custom database changes, as these changes will be overwritten and/or cause problems during upgrades.

[Hemoco]

A sample VMware report (with counts) can be seen below. We still don't see why you would include product key counts however. Your counts will always be 1, unless a VMware guest has multiple keys of the same product. (Why would it?)

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName As GuestName,
tblAssets1.Domain As GuestDomain,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblSerialnumber.Product,
Count(tblSerialnumber.SerialID) As KeyCount
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Inner Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblVmwareGuestNetwork.MacAddress
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Left Join tblSerialnumber On tblAssets1.AssetID = tblSerialnumber.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Where tblAssetCustom.State = 1
Group By tsysAssetTypes.AssetTypeIcon10,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName,
tblAssets1.Domain,
tsysAssetTypes1.AssetTypename,
tblAssets1.IPAddress,
tblSerialnumber.Product
Order By tblAssets.AssetName,
GuestName,
tblSerialnumber.Product

For Hyper-V, we recommend using a separate report (below), as Hyper-V data is stored in different database tables.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName As GuestName,
tblAssets1.Domain As GuestDomain,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblSerialnumber.Product,
Count(tblSerialnumber.SerialID) As KeyCount
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblHyperVGuest On tblAssets.AssetID = tblHyperVGuest.AssetID
Inner Join TblHyperVGuestNetwork On tblHyperVGuest.hypervguestID =
TblHyperVGuestNetwork.HyperVGuestID
Inner Join tblAssetMacAddress On tblAssetMacAddress.Mac =
TblHyperVGuestNetwork.MacAddress
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Left Join tblSerialnumber On tblAssets1.AssetID = tblSerialnumber.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Where tblAssetCustom.State = 1
Group By tsysAssetTypes.AssetTypeIcon10,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName,
tblAssets1.Domain,
tsysAssetTypes1.AssetTypename,
tblAssets1.IPAddress,
tblSerialnumber.Product
Order By tblAssets.AssetName,
GuestName,
tblSerialnumber.Product

[techieanalyst]

The report is showing me the actual keys, not the desired result

I just want a report that shows

Host - VM Name - License Count

Example

Host A

- VM Test

- MS Office 1
- Microsoft Windows Datacenter 1

Thats the report i need

It also needs to include hyper-v servers

[Hemoco]

If there are no report results, none of your ESX(i) servers have been scanned. To scan a VMware host, do the following:
• Create a VMware credential under Configuration/Scanning Setup/Scanning Credentials by hitting the Add New Credential button.
• Submit the machine for IP Address Range Scanning, in the Configuration/Scanning Setup/Scanning Methods section of the Lansweeper web console.
• Map the machine’s VMware credential to its IP range, by hitting the green + button next to the range.
• Hit the Scan All Enabled IP Ranges Now button in the IP Address Range Scanning section of Configuration/Scanning Setup/Scanning Methods to initiate an immediate scan.

Note that we provided you with a product key report, NOT a software report. Software scanning recreates Add/Remove Programs on your machines; product key scanning checks your client machines' registries for product keys.

[techieanalyst]

Im hosting VMs for people and I need to keep an accurate audit of what MS software is installed, so yes its 1 but they may installed another MS Product which would cause us to fail an Audit, so I keep an audit trial of whats on each host to save my butt.

The query came back empty 😞