Notification

Icon
Error

Static Group status - Looking to create a report to get ping status and printer status

Posted: Thursday, November 7, 2019 11:25:50 PM(UTC)
CGIMana79

CGIMana79

Member Original PosterPosts: 2
0
Like
So I have a a static group I created.
It is named PackStation810.

In this group I have the PC, Laser Printer, 4x6" Label Printer, and World Ease Label Printer.

I know some SQL, but there isn't a direct SQL for me to query the database tables to find out where/what the information I am looking for it at.

Basically I am looking to get my Report to look like this:
Pack Station 810 Status: <pingstatus of assetid(pcS/N)>
AssetName pingstatus printerstatus
WH_Laser810 OK Ready
WH_Label810 OK Ready
WH_LabelWE810 OK Ready
Ryan.G
#1Ryan.G Member Administration Posts: 18  
posted: 11/8/2019 3:31:59 PM(UTC)
The ping status you see in the web console is run from the web console the moment you open the page. It's not stored in the database and cannot be reported on.

As we currently don't do monitoring, the only way to get up-to-date information would be to scan the assets almost constantly and checking the last seen dates.

Active Discussions

Lansweeper Check if Netbios is disabled over TCP/IP
by  Wesker305  
Go to last post Go to first unread
Last post: Yesterday at 5:43:02 PM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls   Go to last post Go to first unread
Last post: Yesterday at 4:32:21 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 report
by  RKCar  
Go to last post Go to first unread
Last post: Yesterday at 3:08:52 PM(UTC)
Lansweeper Windows Defender AV
by  Mikey!   Go to last post Go to first unread
Last post: Yesterday at 2:48:54 PM(UTC)
Lansweeper Allow Users and cc Users to edit ticket form field
by  eoinpryan  
Go to last post Go to first unread
Last post: Yesterday at 12:41:05 PM(UTC)
Lansweeper Mobile App
by  jdvuyk   Go to last post Go to first unread
Last post: Yesterday at 2:28:56 AM(UTC)
Lansweeper Duplicate Asset 1 Mac address, 1 domain\computer\1
by  jstrong71  
Go to last post Go to first unread
Last post: 11/12/2019 9:16:58 PM(UTC)