/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Views: 19.5k  |  Created: 03/12/2014 by: pronthep

Average Rating: 0
Office has 0 inventory records, 160 Questions, 22 Blogs and 37 links. Please help add to this by sharing more!

Deployment Tips (2)

Most Common Setup Type
Legacy Setup with command line support
Average Package Difficulty Rating
Rated 3 / 5 (Average) based on 5 ratings
Most Commonly Reported Deployment Method
Vendor Provided Command Line (answer file driven)
or cancel
2
Script
Do you reply/create tickets for KACE via email, but don't want to have to remember all of the variable names and values? Do you sometimes create tickets via email just to quickly get the details of a call down, and later go into KACE to change the variables (such as category, status, etc)? Why not make that a one-step process instead of a two-step?

Create a macro for Outlook!

What I have done is create a macro in Outlook using VBA that gives you an interface similar to KACE's. Inside of this interface, you can title tickets, select categories from a dropdown, and set every other ticket variable with ease. Once you set all the values the way you'd like them, the macro automatically sends an email to your KACE Help Desk email (assuming you have that defined) in the correct format so that KACE can create the ticket using your variables.

This allows you to create and modify tickets, AND set all of the ticket variables, all from Outlook without having to remember each and every variable.

The interface for our implementation of this looks like this:

EF5lAi.png

Basically, after filling all of those fields in, the macro goes into Outlook and creates a new email. In the email, it types lines such as "@category=Passwords::Windows" which KACE sees. Once KACE sees all of this, it automatically creates a ticket and sets all of the ticket fields to whatever you set in the macro.

You can also reply to tickets easily by entering in the ticket number. When a ticket number is entered, the macro includes "[TICK:00000]" in the subject line, which tells KACE which ticket to modify.

This macro has increased our efficiency quite a bit, and I think it can help others as well.

I can share the code and some simple instructions on how to edit it to match your KACE system implementation, if anyone is interested. The VBA coding was painfully simple. Well, most of it was, but did you KNOW how hard it is to allow a mouse scroll wheel to be used on dropdowns in VBA?? Haha!
Setup Information:
Setup Type: unspecified
Deployment Method Used: unspecified
Deployment Difficulty: Very Easy
Platform(s): Windows
  • I'd like to test this out, as I think our helpdesk could really use this as a time saver.
Please log in to comment
1
Note

Install:

Create an adminfile by starting setup.exe from the source with /admin

 The created adminfile.msp can either be placed in the updates folder or be called by:


Setup.exe /adminfile “path-to-file.msp”

 

You can also put the extracted Service Pack into the updates folder to install them together with Office.

 

Uninstall:


Example ProPlus (also works for Standard, Visio, Project, you just need to change the Product):

You can call the Setup.exe from (works for Office, Visio, Project also):

"%programfiles%\Common Files\Microsoft Shared\OFFICE15\Office Setup Controller"

 

Create an “uninstall.xml” with the following content:

 

<Configuration Product="ProPlus">
<Display Level="none" CompletionNotice="no" SuppressModal="yes" AcceptEula="yes" />
<Setting Id="SETUP_REBOOT" Value="never" />

</Configuration>

 

Commandline:

Setup.exe /uninstall ProPlus /config “path-to-uninstall.xml”

 


To Activate:

"c:\windows\system32\cscript.exe" "%Programfiles%\Microsoft Office\Office15\OSPP.vbs" /act


Setup Information:
Setup Type: Legacy Setup with command line support
Deployment Method Used: Vendor Provided Command Line (answer file driven)
Deployment Difficulty: Somewhat Easy
Platform(s): Windows
  • If you put the uninstall.xml in a shared location, this will work for Office 2016 as well.
Please log in to comment

Inventory Records (0)

View inventory records anonymously contributed by opt-in users of the K1000 Systems Management Appliance.

Versions

Questions & Answers (160)

Questions & Answers related to Microsoft Office

1
ANSWERS
1
ANSWERED
1
ANSWERS
1
ANSWERED
1
ANSWERED
4
ANSWERS
4
ANSWERS
3
ANSWERS
1
ANSWERS
1
ANSWERED
1
ANSWERED
1
ANSWERS
2
ANSWERS
2
ANSWERS
2
ANSWERS
1
ANSWERED

Blogs (22)

Blog posts related to Microsoft Office

blog
blog
blog
blog

Reviews (0)

Reviews related to Microsoft Office