Need help creating a K1000 Smart Label that looks for startup programs
I'm not seeing an option in the Create Smart Label form fields for testing startup programs or processes. Both are recorded but not sure how to tap into this.
Ultimately I'm sure I'll be looking for an SQL statement to accomplish this. Is there a place one looks to find a list of these fields to search by?
Answers (3)
If you are looking for a specific process or startup program, you could probably use a custom data field and then a smart label.
http://www.kace.com/support/resources/kb/article/What-are-the-steps-to-create-a-custom-data-field-Inventory
https://www.kace.com/support/resources/kb/article/Writing-Command-Line-Output
You can get the database schema by connecting and using a command similar to this:
show tables;
desc <TABLE_NAME>
How to connect: http://www.kace.com/support/resources/kb/article/Can-I-access-the-K1000-appliance-database-using
Interesting that the inventory data isn't available to create a smart filter! That being the case, you can create a Custom Inventory Field using the command wmic startup get caption to put the data into a field that you can use in a smart label.
- On your K1000 go to Inventory->Software and select the "Add New Item" action
- Give it a name and notes, etc
- In the Custom Inventory Rule section put ShellCommandTextReturn(wmic startup get caption)
- Test it by forcing some computers to do an inventory update.
Now you can see your new custom field down past the built-in fields when creating a smart label... use the "Contains" operator and there you go!
Top Answer
Comments:
-
Awesome Jamie! I can't remember what I wanted this for, but I'll test this out for sure! - worzie 7 years ago