About Alexey

Alexey · 10-05-2021

Hi!Can I specify the "last logon" variable of the user in the description of a specific computer?For example, I have a "pc-20-18" computer with AssetID = 516. The last logged in user on it is always the same, because this is his personal corporate PC...

Alexey · 11-02-2021

Hi prighi61,Understood you, thanks! How wrong I was thinking that this is something not complicated  As a solution by using a trigger, I cannot solve this on my own, given your latest versions of scripts. So I will look for other options for now.

Alexey · 11-01-2021

prighi61 wrote:...However, instead of using a union you can check whether @Displayname is null or empty and set it via another select.CREATE TRIGGER mytrigger ON [tblAssets]AFTER UPDATE ASBEGIN SET NOCOUNT ON; DECLARE @Displayname nvarchar(301), @d...

Alexey · 10-29-2021

prighi61 wrote:prighi61 wrote:Hi Alexey T, you can try this:CREATE TRIGGER mytrigger ON [tblAssets]AFTER UPDATE ASBEGINSET NOCOUNT ON;DECLARE @Displayname nvarchar(301), @deletedUserdomain nvarchar(150), @deletedUsername nvarchar(150), @insertedUserd...

Alexey · 10-28-2021

Thanks a lot again!!!I'll try it soon, as soon as I have free time again 

Alexey · 10-28-2021

Hey again! Checked the trigger. To my surprise, it was executed even through a report inside the LanSwepper web interface! But now I realized that I would like to display slightly different information, namely the "display name", and not "username"....

User Statistics

User Activity

Last logon on description is real?

Re: Last logon on description is real?

Re: Last logon on description is real?

Re: Last logon on description is real?

Re: Last logon on description is real?

Re: Last logon on description is real?