About ajokerst

ajokerst · 11-19-2018

Hi there,I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?Sel...

ajokerst · 03-06-2019

I would also like the Hyper-V report

ajokerst · 11-20-2018

You can try this code. However, keep in mind that it also gets empty disks (CD-RW) as well. It definitely has room for improvement. Perhaps someone here can refine it?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTy...

ajokerst · 11-20-2018

galesj wrote:This is perfect, thank you very much.I'm shaking my head at how little code you used to get the job done lol.I did have to switch the order so the Chart widget shows correctly:Select Top 1000000 web50repchassisoverview.ChassisName, Coun...

ajokerst · 11-19-2018

Hi there,Yep it's already there. If you go to an asset page and hover over config you will see several things you can look at. At this point it is just choosing what you want.

ajokerst · 11-19-2018

OK so this is a bit of a hack using an existing report. So you can sort of understand what is going on I will give a high level overview of what I am doing... So Lansweeper stores its reports in SQL as "Views". Views are pretty much cherry picked tab...

User Statistics

User Activity

USB printers with toner levels

Re: Virtual machines and their host

Re: Report for Discs in Drives e.g. CDs/DVDs etc.

Re: Chart report with count of Chassis Type

Re: Report on single server

Re: Chart report with count of Chassis Type