Custom Report Request

[jonnyni]

Hi All,

I have a number of custom reports I have a requirement for:


Can lansweeper be configured to:

Do a processor core count per processor
i.e intel xeon quad core processor or intel xeon 10 core processor

Can the allocation of processor core to virtual machine be collected?

Can the edition of SQL and exchange be reported on? For example:

- sql standard,

- sql enterprise,

- sql datacentre

- sql express

- exchange standard / enterprise

Find out if lansweeper can query the host that each the vm is associated to.

These really are essential pieces of information in order to carry out an accurate inventory for a SAM audit as the information of these variables can massively impact on license price, i.e sql express is free sql datacentre on the pre 2012 license model is £25k per processor, add in the factor that with sql 2012 licensing rules being calculated on per processor core count then this information is essential in order to accurately license your estate

Any assistance would be massively appreciated.

Many thanks

Jonny

[Hemoco]

A copy of our email correspondence with the OP can be found below.

Please try the report below for the processor information you are after.

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname,
Web40OSName.Compimage As icon, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.Name, web40ProcessorCapacity.MaxClockSpeed As
ClockSpeed, web40ProcessorCapacity.NrOfProcessors, tblPROCESSOR.NumberOfCores
From tblComputers Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
web40ActiveComputers On web40ActiveComputers.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Left Join
tblPROCESSOR On tblPROCESSOR.Caption = web40ProcessorCapacity.Name
Order By web40ProcessorCapacity.NrOfProcessors Desc, tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.


Currently, the only way to retrieve SQL edition details is through custom registry scanning: http://lansweeper.com/forum/yaf_postst6099_Query-SQL-Server-Version-standardeveloperenterprise.aspx
The problem is that this information is not included in the software name listed under Add/Remove Programs, which is why Lansweeper cannot scan it by default. We plan on implementing a procedure to make SQL edition detection easier in the future, but we do not currently have a release date for this feature.


“Find out if lansweeper can query the host that each the vm is associated to.”
This is not currently possible. This feature will be added in Lansweeper 5.0, which is currently in development. We expect to have a 5.0 beta release ready by October. Previews can be seen on our Facebook page: http://www.facebook.com/lansweeper.network.inventory

[FCF_IT]

Is this possible or not? We would also like to get this information out of Lansweeper if possible.

[Hemoco]

Reply sent through email.