Iyad
Engaged Sweeper
since ‎12-24-2020
‎07-11-2022

User Statistics

  • 2 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi,I need to build a report that shows me, users, from the active directory and their laptops filtered bu AD user OU please assist
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Username, tblAssets.IPAddress, tblAssets.Description, Max(Convert(date,tblQuickFixEngineering.InstalledOn)) As lastPatchDate, tblAssets.Lastseen, Case When...