Unable to figure this out. I've tried using the SQL Server Compact documentation, but I can't figure out which one to use and functions like CONVERT(date, <datecolumn) through date = unknown data type.
Hi all,i gave the best i can do but now im stuck and i dont get the Report to work HALP! What i want:create a Report for all Assets that looks if the Asset is in more than one Asset Group, if it has 2 or more Asset groups assigned dont show it. So s...
Hello,I'd like to make a report that pulls out a substring of the FTP header. My current report pulls tblAssetCustom.FTPheader but I'd like to get a version number out of it. The version number doesn't always appear at the same index for each asset...
HiLooking for tips on how to create a report of active users in AD, possibly by OU, that have no computer associated with their account.For a variety of reasons, we have some machines that are not in the LS database, and corresponding users who have ...
Hi there ! I've seen on some other post people asking for help on removing duplicate. I tried to replicate some of the answer given but I'm not really good with these queries. Can someone help me remove duplicate from this report either by assetname ...
Hello,I am new here and also new in LANSweeper. Can someone help me create a report on how to identify machine which doesn't have Trend Micro Disk Encryption installed? We are using Windows 7, 8 (both 64bit) on our environment.We are also using MAC O...
