Missing Licenses

techieanalyst · ‎07-23-2013

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 · ‎07-24-2013

A list of scanned product keys (and product IDs) can be found in the Lansweeper web console under Configuration\License Compliance\Product Keys.
- If the product keys you are after are included in this list, please ensure that your computers have recently been (successfully) scanned in order to detect these keys. The “last seen” dates listed for your computers should be recent. Product keys can be found on computer webpages under “Software”. You can also use the built-in report “License: Software licensekey overview”, found under Dashboard\Reports\All Reports, to retrieve a list of scanned product keys.
- If the product keys you are after are not included in this list, you can submit additional registry locations for scanning in the Lansweeper web console under Configuration\License Compliance\Product Keys. We have not been able to track down product key locations beyond what is listed in the web console however.

You can manually add license keys to the database as well, as part of license tracking. License tracking is configured under Configuration\License Compliance\License Tracking. You can create a license item (a collection of software packages), link orders to it and manually submit license keys as part of these orders.

View solution in original post

Hemoco · ‎08-16-2013

Could you clarify what you are trying to do. Are you simply trying to list the guest machines' installed OS (edition and version) or are you trying to list the OS product key?

- If the former: sample reports below.
- If the latter: as stated previously, there is no "publisher" field for product keys. You would have to manually filter the product names to only report on Microsoft (OS) products.

If you have further report requests, please try modifying some of our sample reports first. We've posted close to a dozen queries.

VMware

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,
tblOperatingsystem.Caption As GuestOS,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblAssets1.NrProcessors As GuestNrProcessors,
tblProcessor.NumberOfCores As GuestCoresPerProcessor
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
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
Left Join tblOperatingsystem On tblOperatingsystem.AssetID = tblAssets1.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
GuestName

Hyper-V

Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblProcessor.NumberOfCores,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName As GuestName,
tblAssets1.Domain As GuestDomain,
tblOperatingsystem.Caption As GuestOS,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblAssets1.NrProcessors As GuestNrProcessors,
tblProcessor1.NumberOfCores As GuestNumberOfCores
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
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Left Join tblProcessor tblProcessor1 On tblAssets1.AssetID =
tblProcessor1.AssetID
Left Join tblOperatingsystem On tblOperatingsystem.AssetID = tblAssets1.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
GuestName

techieanalyst · ‎08-14-2013

I know Im a pain lol

I only want the MS OS Licenses info, example MS Server 2003, 2008 r2 etc datacenter, I need that info

Hemoco · ‎08-14-2013

Hyper-V report:

Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblProcessor.NumberOfCores,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName As GuestName,
tblAssets1.Domain As GuestDomain,
tsysOS.OSname As GuestOS,
tsysAssetTypes1.AssetTypename As GuestType,
tblAssets1.IPAddress As GuestIP,
tblAssets1.NrProcessors As GuestNrProcessors,
tblProcessor1.NumberOfCores As GuestNumberOfCores,
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
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Left Join tblProcessor tblProcessor1 On tblAssets1.AssetID =
tblProcessor1.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets1.OScode
Where tblAssetCustom.State = 1
Group By tsysAssetTypes.AssetTypeIcon10,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tblAssets.NrProcessors,
tblProcessor.NumberOfCores,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets1.AssetName,
tblAssets1.Domain,
tsysOS.OSname,
tsysAssetTypes1.AssetTypename,
tblAssets1.IPAddress,
tblAssets1.NrProcessors,
tblProcessor1.NumberOfCores,
tblSerialnumber.Product
Order By tblAssets.AssetName,
GuestName,
tblSerialnumber.Product

techieanalyst · ‎08-14-2013

Hyper-V?

techieanalyst · ‎08-13-2013

Instead of Software, just the OS Version would be awesome

techieanalyst · ‎08-13-2013

Can the query be written to include all Hosts and VMs?

I know you say Xen cant be scanned but at least can those come after and I can just full the blank fields in an excel sheet?

Hemoco · ‎08-14-2013

techieanalyst wrote:
Can the query be written to include all Hosts and VMs?

No. As stated previously, other host data (e.g. Hyper-V data) is stored in different database tables. We added the OS version to the sample VMware report below.

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,
tsysOS.OSname As GuestOS,
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
Left Join tsysOS On tsysOS.OScode = tblAssets1.OScode
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,
tsysOS.OSname,
tsysAssetTypes1.AssetTypename,
tblAssets1.IPAddress,
tblAssets1.NrProcessors,
tblProcessor.NumberOfCores,
tblSerialnumber.Product
Order By tblAssets.AssetName,
GuestName,
tblSerialnumber.Product

techieanalyst · ‎08-09-2013

What about a report that just shows the following:

Host / #CPUs / #Cores per CPU/ VM / #Cpus / #Cores per CPU / License

License = Windows Server, the license doesn't need to be displayed

techieanalyst · ‎08-09-2013

Not seeing xen listed?

Missing Licenses

New to Lansweeper?

Try Lansweeper For Free