/build/static/layout/Breadcrumb_cap_w.png

[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

0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 11 years ago
Red Belt
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,
Posted by: snissen 11 years ago
Fourth Degree Green Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ