This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Hi all, I am a complete noob when is comes to SQL.I have a report set up to report failed log on event 4625, but I would like to parse information from the message:Information I would like to have:Account Name:Account Domain:Failure Reason:Workstatio...
Hi,Our current chappie who looks after Lansweeper is on long term sick, so I am trying to find my way around in his absence. I've noticed on reports that each asset is duplicated for some reason. I seem to recall this occurring before and my colleagu...
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...
