Hi guys,LanSweeper has proven to be a very useful tool in monitoring and managing assets.However, we're finding we need to look elsewhere for certain business requirements.Governance is becoming more of a requirement and I was wondering whether anyon...

Hi there,I'm quite new to writing up SQL queries and am having some difficulty producing particular reports. Hoping someone can help!In this report, I'm using the last seen user and their respective department listed in AD.I'd like to expand on the f...

Hi there,I'm trying to organise a report listing assets which have been given a specific location of "Inventory" but not having much luck.Anyone know how this can be achieved?

Hi all,I'm relatively new to this and could use some help.I'm trying to fine tune this report to show computers in AD and want a column for the last seen users' departments polled from AD.Select Top 1000000 tblAssetCustom.AssetID, tblAssets.AssetUni...