This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Hi Lansweeper Community,I'm looking for help with a custom report that I can give to our accounting department. What is needed is - All Assets (monitors, computers, WAPs, Printers, etc...)Asset NameAsset TypeModelSerialMAC AddressIP Address if avail...
We currently have a 7 year refresh cycle on our hardware. I have created a report to display machines that have hit their 7 year mark. I am wondering if there is a quick way to, when a computer hits that time, automatically send an email with the c...
Select count(*), tblADGroups.Name As ADGroupNameFrom tblADMembership Left Join tblADGroups On tblADMembership.ParentAdObjectID = tblADGroups.ADObjectID Right Join tblADusers On tblADMembership.ChildAdObjectID = tblADusers.ADObjectIDWhere tbl...
Ciao,If after a year I decide not to renew my Professional license again, can I continue to see all my assets or does Lansweeper return to working demo mode by displaying only 100 assets?Thanks in advanceGianluca
Hi there,actually, in the uptime calendar you get the Information "Poweron 00:00 - 11:11" or anything similar.Would be great, if this could be with the Duration, for example "Poweron 4:10 - 6:30 for 2h 30m"Regards, Jochen
Trying to get a specific date for the report belowSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblNtlog.TimeGenerated, tblAssets.Description, tblAssetCustom.Model, tblNtlog.Eventcode, tblNtlogSource.Sourcename, tblNtlogMessage.M...
Hi, can anyone help me how can I generate a report to view a list of computers that connected to which network switch and port?Example: Realtek PCIe GBE Family Controller - xx:xx:xx:xx:xx:xxxx.xx.xx.xx *switch hostname* 98 | GigabitEthernet2/0/3...
Hello,I see the default built in All servers shows all the serversand the separate reports Server: 64 bit windows and Server: 32 bit windows show them individually.Is there a way to add a column that says which it is.Like adding it to Server: All ser...
