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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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,
Answered 05/31/2010 by: KevinG
Purple Belt

Please log in to comment
0
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.
Answered 06/10/2010 by: snissen
Fourth Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity