Is there any plan to create a custom help desk rules forum? I've got a ton of useful stuff to share. The Reports forum is great! However, it would be nice if a few other forums were created as well - Assets, Help Desk (maybe even break out Custom SQL Rules as a sub-forum), Security, Scripting, etc.
1 Comment   [ + ] Show Comment

Comments

  • I know this is an older post, but exists the "Help Desk Rules forum" now? I haven't found it..
    Thank you!
    • You can likely just post in Q&A now and get some help. When I posted this, I was a customer. I now work for KACE and still write/publish rules publicly from time to time - all of those are available in the Dell Software Portal / Knowledge Base. We also offer Professional Services to write rules for you (fee-based).
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
The plan is to grow this as demand dictates and we're happy to see the demand. We'll be turning on a forum for scripts and ticket rules shortly!

Thanks,
Bob
Answered 01/15/2010 by: bkelly
Red Belt

Please log in to comment
0
Sounds great! I've got plenty of custom ticket rules to post!
Answered 01/15/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
It is needed. This will be more useful once we have the ability to export rules as a package like we can with scripts and reports. This is something in the works.
Answered 01/19/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Like
Answered 01/20/2010 by: Jiddle
Orange Senior Belt

Please log in to comment
0
Sounds good to me!!
Answered 02/02/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
I have some needs right now so I'm all for this
Answered 02/02/2010 by: kdasanmartino
Second Degree Green Belt

Please log in to comment
0
Feel free to post threads to the KBOX 1000 forum if you need help writing any help desk rules. I'd be glad to help! I may have even written some of your needed rules already... I've written hundreds of custom rules and reports in our database.
Answered 02/03/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Hey, airwolf, since you asked for people writing help desk rules...

I want to write custom SQL that updates a custom inventory field in the ASSET_DATA_5 table from a field in the corresponding record in the MACHINE table, as linked through the corresponding ASSET table record. (BTW, why am I doing this? I'm trying to set up for a periodic Computer Asset import based on serial number.)

Now, I can write the correct SELECT query for this, and I refined and tested it using MySQL Workbench, thanks to your first blog article. I can see from the SELECT query that I'm getting the correct data with the correct table relationships.

I can't test the actual UPDATE query with its SET clause, because MySQL Workbench doesn't have write access to the database. But I'm pretty sure I have the syntax of the UPDATE query correct, because I've written quite a few UPDATE queries before in various SQLs, and because the equivalent UPDATE query works in a mirror database in Microsoft Access.

So what am I asking you? I'm not sure how to fill in the Ticket Rule : Edit Detail screen. I know my UPDATE query goes into the "Update Query" textbox, but what do I put in the "Select Query" textbox, since I'm not doing anything related to tickets? Do you have any rules that use custom SQL to update something not related to tickets? If so, could you post an example here?

I think that's where my problem lies, because when I try to run the rule with the "Select Query" textbox empty, I get an error message, something about 0 records returned in the Select Query EXECUTE(). (I'll have to get the exact error message on Sunday night, and I'll post it here.)

Any examples, or any advice, would be greatly appreciated. I may not be feeling so adventurous by next week... Sande
Answered 04/16/2010 by: snissen
Fourth Degree Green Belt

Please log in to comment
0
If your update query works standalone, then you can put any query in the "Select query" box - as long as it returns results. For example, SELECT * FROM HD_TICKET. Whatever you use MUST return results in order for the Update Query to be run.

The purpose of the Select query statement is to pass ticket IDs to the Update Query (i.e. filter results in your select query, and then pass the IDs to the update query using <TICKET_IDS>. This allows you to make a very simple update query - you're basically splitting the work in to two pieces). You can also use this to pass other data to the Update Query, but you have to "trick" it into moving data by naming whatever column you want data from to "ID".
Answered 04/19/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
[font="trebuchet ms"]Got it! My rule now puts the serial number from the MACHINE table into a custom inventory field in the ASSET_DATA_5 table, as linked through the corresponding ASSET table record. Thanks, Andy!

I really appreciate a system that lets me store and schedule UPDATE queries on any table. In other systems without this capability, I spend a lot of time with Access queries I have to run manually. Thanks, KACE!
Answered 04/27/2010 by: snissen
Fourth Degree Green Belt

Please log in to comment
0
If I am reading this correctly ( hopefully I am ) you are using items he client reports normally to fill in field(s) in the asset detail for custom fields?
I would love to see how you would be able to edit to fill in other fields as I would find this immensely useful. I currently have several custom fields I have to hand enter that is already reported by the client that I would LOVE to see automatically filled in for me such as model and chassis type.

Thanks!
Answered 05/19/2010 by: JesseLara
Orange Belt

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