Our environment is largely thin client devices and printers which of course the AMP cannot be installed on. When creating assets I can link them to PCs which have AMP installed.

How can I link assets to other items the IP scan has found? Using the option of SNMP in IP Scan I can easily identify all my thin client devices and printers, but its not much use viewing them here (even automatically labelled by the Scan Filter with appropriate labels), if I cant link these to asset records like you can with PCs?

Ideally I'd like to scan for thin clients (which tells me its IP and SNMP description which is all I need to know) , then link them to an Asset Record which tells me when it was purchased and warranty info etc.

Hope that makes sense

Thanks

StuBox
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
You can do this using custom help desk rules, but DellKACE discourages inserting data into tables (which is what you would be doing by creating assets based on IP scan results). Is it possible? Yes. However, it's a bit dangerous to perform this type of database modification. Also, writing the rules is going to take some time, as they are rather complex.
Answered 07/29/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Thanks for the info Airwolf.

Is there any way I can link an Asset record to a device discovered by the IP scan? (within the Kbox's existing functionality)

I could just create a new text field within the Asset and manually enter a unique identifier for the device. i.e. if the IP scan found a printer and it's hostname is PRINTER1, I could manually type in PRINTER1 in the new Asset field. Then, when a user needs to know when the printer was bought, the Asset record would tell them, and if they wanted to know its IP, they could search for the unique identifier (PRINTER1) in the IP Scan results page and find the printer.

This kind of takes the fun out of the Kbox though!

If anyone has any suggestions of how I could do this better it'd be much appreciated. Even if it were possible to choose an IP Scan discovered device from a dropdown list field in the Asset would be slightly quicker.
Answered 07/30/2010 by: stubox
Blue Belt

Please log in to comment
0
There is absolutely no way to link IP scan data to assets without the use of custom SQL rules in the helpdesk.
Answered 07/30/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
That is a shame, thanks Airwolf.

I'll submit a support ticket with Kace to see if they have any other ways I can work it to achieve the same without touching the database tables.
Answered 08/03/2010 by: stubox
Blue Belt

Please log in to comment
0
I'm not saying the end result you are looking for is not possible, it's just a bit risky. It all depends on how far you want to push your KBOX. Virtually anything is possible (database-wise) with custom help desk SQL rules.

On a side-note, I'd love to see an automatic link for IP Scan results and assets. I've already submitted a feature request for this, and I'd suggest you do the same (enhancement requests are sent in as support tickets to DellKACE - you'll see it as a "priority" level).
Answered 08/03/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Hi airwolf

On a side note but still kinda relevant to the topic - can you show me an example of a custom Helpdesk SQL rule?

Say for example, I wanted to populate a field called AuditDate in all my assets by external means e.g. run a script that sets all asset's AuditDate field to 01/09/2010.

Whats the first step?
Answered 08/19/2010 by: stubox
Blue Belt

Please log in to comment
0
For updating only PCs running XP I guess it would be something like:

UPDATE MACHINE.AuditDate
SET MACHINE.AuditDate = "01/09/2010"
WHERE MACHINE.OS_Name = "Microsoft Windows XP Professional"

Where would I run this SQL? Create it as a helpdesk rule?
Answered 08/19/2010 by: stubox
Blue Belt

Please log in to comment
0
The only way to run SQL against the KBOX database is in the form of a Custom Helpdesk Rule.
Answered 08/23/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Thanks Airwolf

I've had a play with the Helpdesk SQL rules and experimented with a few simple, safe changes such as just changing the title of a ticket.

Does the Select Query have any bearing on the Update Query? i.e. can I use an irrelevant Select query (just because it needs something in that field), but then update, say, the knowledgebase table, is that possible?
Answered 08/24/2010 by: stubox
Blue Belt

Please log in to comment
0
....to clarify by Select Query I mean the field on the Helpdesk rules page, not a sql select query in general, but the box on the page it asks you to fill in.
Answered 08/24/2010 by: stubox
Blue Belt

Please log in to comment
0
You are correct. The select query and update query only interact with one another if you use the <TICKET_IDS> variable in the update query. You can simply put SELECT * FROM HD_TICKET in the select query and update an entirely different table if you'd like.
Answered 08/24/2010 by: airwolf
Tenth Degree Black Belt

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