I personally do not want to see assets in the last 30 days, I want to see them older than 30 days. I used the statement below this instead of "Where tblAssets.Lastseen < GetDate() - 30"Where tblAssets.Lastseen Between DateAdd(day, -999, Current_Time...
Hello,I find this works best for last seen computers over 30 days view. The date format in this shows me 31 to 60 days only.tblAssets.Lastseen Between DateAdd(day, -60, Current_TimeStamp) And DateAdd(day, -31, Current_TimeStamp) Here is for which as...
:Prompt to Run as administratorSet "Variable=0" & if exist "%temp%\getadmin.vbs" del "%temp%\getadmin.vbs"fsutil dirty query %systemdrive% >nul 2>&1 && goto :(Privileges_got)If "%1"=="%Variable%" (echo. &echo. Please right-click on the file and sele...
I think this date format works better. For PC's lastseen older than 30 days.Where tblAssets.Lastseen Between DateAdd(day, -60, Current_TimeStamp) And DateAdd(day, -31, Current_TimeStamp) And tsysAssetTypes.AssetTypename Like 'Windows%' And tblComp...