About ToMonkey

ToMonkey · 07-22-2019

I've wrote this report so I can import the data into our helpdesk systems CMDB, this is a nightly process and the CMDB is a read only direct from Lansweeper. This report gives me all the detail except I've been trying to get only the latest owner whe...

ToMonkey · 10-18-2018

OK, So I'm looking at writing a reboot report I've been working on this for and age.Essentially I want to take the date today increase the month by one and start from the 8th of that month to find out when our first day to start rebooting is (2nd Tue...

ToMonkey · 05-31-2017

Hi, Never used Lansweeper before or SQL and I've put together a report based on others work in the forum plus the standard reports. I want quite a lot of detail to load into a spreadsheet which then provides disaster recovery plans.Essentially it kin...

ToMonkey · 07-23-2019

Worked it out finally, I added another sub query to give me the max date and then used that in the first sub query to get only one record, it works now.Other things I tried, sorting the first sub query in descending order and choosing only the top 1,...

ToMonkey · 10-19-2018

OK so I have it now where I can get the second Tuesday of the month as below.Why can I not reference RebootDate in a formula for another field, how would I do this? Case When DateName(dw, DateAdd(month, 1, DateAdd(day, 8 - DatePart(dd, GetDa...

ToMonkey · 10-19-2018

Thanks for that I already have part of it done as follows:NextRebootBase = DateAdd(month, 1, DateAdd(day, 8 - DatePart(dd, GetDate()), GetDate()))Still don't understand though why I can't use the NextRebootBase field as the source for other calcs i.e...

ToMonkey · 06-08-2017

I'm using this report (Thanks) but in some cases I get duplicate server entries and have a hard time working out why.Do you have any idea, the first time it appears the VM host is correct but for the second entry it is not.

User Statistics

User Activity

Getting only the first Owner of an Asset

Working with Dates in Reports

Drive Space Report

Re: Getting only the first Owner of an Asset

Re: Working with Dates in Reports

Re: Working with Dates in Reports

Re: One field that shows VM or Hyper-V host