Wondering if anyone can help me with the following:
I am trying to use the Discovery results to create a report of all machines on our network. The problem is that we do not install the Kace Agent on any servers. I'd like to have the report only show the OS and count of machines with that OS installed.

I created a simple report of the inventoried machines:
SELECT CHASSIS_TYPE, OS_NAME, COUNT(OS_NAME) as COUNT  FROM MACHINE GROUP BY CHASSIS_TYPE, OS_NAME

Something similar using Discovery results would be ideal, right now I have list of >1,000 host names and OS's
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
Here is what you can use but with the servers, if their information isn't in the KBOX, you can't report against it. An option would be to manually add the information into the KBOX as a one time deal. 

You could try this by using the KInventory.exe file from a agent based machine

https://support.software.dell.com/k1000-systems-management-appliance/kb/111170


Select
  MACHINE.OS_NAME, COUNT(MACHINE.OS_NAME) AS Count
From
  MACHINE
GROUP BY MACHINE.OS_NAME
Answered 05/25/2016 by: nshah
Red Belt

Please log in to comment
1
If you want to get the Server info in your KACE but won't install an agent, you can use agentless inventory.
Choose WinRM to collect all info. You will not be able to run scripts or MI or patching etc against the machines but they will regulary update their inventory and show if they are online or not.
Answered 05/31/2016 by: Nico_K
Red Belt

  • Will this be eat up licenses if I do agentless inventory?
    • WinRM and SSH yes, since it is like the agent inventory. If you use SNMP, no.
Please log in to comment
Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share