HiIm using the Web Console access report bellowHow can i change it so that it will only show each users first login on every day, instead of showing me logging in 3 times on one daySelect Top 1000000 tblLoginLog.Date As LoginDate, Case tblLoginLog.S...

Hi GuysI have a report that finds all of are mobile phones and how a Sim card is related to them, I.E Housed IN, how can i also get the report to show devices that have no asset relations?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, t...

Hi I have a report that shows all of the mobile devices in the company, how can I get it to show the related info for the SIM card in the device. Bellow is what I have so far, just basic but can't work out how to link the SIM detailsSelect Top 100000...