This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
I am trying to get a report of computers and accounts that fail logon:the following does not give me enough information:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblNtlog.Eventcode, tblNtlog.TimeGeneratedFrom tblAssets Inner Join...
Hi,I am trying to produce a report on the following criteria,Users Fist NameUsers Last nameUsers managers nameNumber of tickets logged of a certain type (replacement laptop)Ideally i would like the below output if thats doable?First Name Last Name...
Hi,Does anyone know how i would get a report containing the following criteria;Username (AD)Users managers name (AD)Ticket Type (i.e. replacement laptop / phone)Ticket IDThanks,Dave
When changing User ticket concerning no reg. in "History" tab?I need this because sometimes we´ll need to change the user to an external company to keep all messages about the case in same ticket and at the same time avoid that the end user gets any ...
Sometimes users need to be able to create a ticket from web and add an external user/mail that does not already exist.Only agents can add/create a new external user?
There is the potential to vastly improve upon reporting if we could execute stored procedures or sql queries in te context of the current user rather than the service account. This could be simply facilitated by allowing the use of parameters such a...
Hi all,First post here, I've been viewing the forum for awhile while getting all my custom reports set up (no experience with SQL) and I've been able to figure everything out until now! Trying to generate a report that shows all PC's without an SSD,...
Hello,I am trying to get a report on how many times and what computers users have logged on to in the past 30 days. If possible also to group the computer likeUser A has logged on 17 time to PC1, PC2, PC3.Thanks,
