[SOLVED] Stupid question: view only connected computers?
OK, here's a question which reveals just how new to the KBOX I am:
When looking at the Inventory->Computers list, I know how I can search, sort, restrict view by existing machine labels, and hide/show labels. And I can tell which computers are currently AMP-connected by their green link icon.
But is there a way to limit the view to only currently AMP-connected computers?
Yes, I can sort on that column, but if I do so, I lose the alphabetical Name sort order I had before. What I want is only currently connected computers, sorted by Name. The closest I've come is to restrict Last Sync > (today with a recent time).
Any hints are appreciated. Sande
When looking at the Inventory->Computers list, I know how I can search, sort, restrict view by existing machine labels, and hide/show labels. And I can tell which computers are currently AMP-connected by their green link icon.
But is there a way to limit the view to only currently AMP-connected computers?
Yes, I can sort on that column, but if I do so, I lose the alphabetical Name sort order I had before. What I want is only currently connected computers, sorted by Name. The closest I've come is to restrict Last Sync > (today with a recent time).
Any hints are appreciated. Sande
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
KevinG
14 years ago
AFAIK there is no simple way just from the Inventory->Computers list without using a filter.
You may be able to use the following SQL statement to create a Filter or Smart label.
SELECT * FROM ORG1.MACHINE M LEFT JOIN KBSYS.SMMP_CONNECTION AS S ON M.KUID = S.KUID WHERE S.CLIENT_CONNECTED = '1' ORDER BY NAME;
You could create a SQL report if all you want to know is what computers are connected,
You may be able to use the following SQL statement to create a Filter or Smart label.
SELECT * FROM ORG1.MACHINE M LEFT JOIN KBSYS.SMMP_CONNECTION AS S ON M.KUID = S.KUID WHERE S.CLIENT_CONNECTED = '1' ORDER BY NAME;
You could create a SQL report if all you want to know is what computers are connected,
Posted by:
snissen
14 years ago
Thank you. That KBSYS.SMMP_CONNECTION.CLIENT_CONNECTED= 1 is what I needed to know.
Though, upon further reflection, it's not useful as a label, because a machine doesn't get the label until it checks in, and still keeps the label after it disconnects.
If ever it becomes possible to select these directly in the Inventory user interface (for example, under View by:, a new option like AMP Connected), I can use that functionality.
Though, upon further reflection, it's not useful as a label, because a machine doesn't get the label until it checks in, and still keeps the label after it disconnects.
If ever it becomes possible to select these directly in the Inventory user interface (for example, under View by:, a new option like AMP Connected), I can use that functionality.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.