Updated with 1809 + last logged in user:Select Top 10000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tsysOS.OSname, tblOperatingsystem.Lastchanged, tsysOS.Image As icon, tblOperatingsystem.Version As Build, Case tblOperatingsys...
I worked it out Displays:Asset Tag of Device | Last User to Login to device | Alias of Port (DeskCode) | Asset Type | Asset MAC address | Switch | PortSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Username, tblSNMPInfo.ifAl...
Hi all,Please forgive my ignorance, as I'm new to LS reporting.On the switch asset pages there is a field "Alias" which is the port description on our Dell switches.How would we input this data to the report.We use this as our ports are named in rela...