Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Need An Automated Collection Subscription Tool

Created: 26 Apr 2007 • Updated: 26 Apr 2007 | 10 comments
jasoncordell's picture
5 Agree
0 Disagree
+5 5 Votes
Login to vote

Hey Everyone,

I am looking for a tool, or way to create a tool, that will assist me in our re-imaging process. Basically, all of our non standard-image workstation applications will be delivered via Authorized Collections in NS.

When we do hardware replacements, we currently need to unsubscribe the old computer from the authorized collections and place the new computer in the same ones.

I would think that we (someone) should be able to write an app that would do the following:

  1. Allow entering the old and new computer names:
    • manually
    • easily selecting from current data pulled from DS
    • importing from CSV
  2. Identify all collections with "authorized" in the name.
  3. Remove old computer(s) from those collections.
  4. Add new computer(s) to those collections.
  5. Provide detailed logging for troubleshooting purposes.
  6. And just to be greedy, open incidents for each computer including a list of all collection changes made for that computer in Altiris Helpdesk.

I was told that I should look to the ASDK to tackle this. Since I don't have much VB or SQL experience, any help or insight would be greatly appreciated, especially if someone has already created such an animal.

Thanks,
Jason

Comments 10 CommentsJump to latest comment

Screenbert's picture

I think that the Juicemaster should put a bounty for just such a tool!

Screenbert

Screenbert

0
Login to vote
Admin's picture

Arrrg, I'll have to check with the Cap'n, mate.

JM

0
Login to vote
Admin's picture

I talked to the pirate who holds the purse strings and we've settled on a 500 point purse to the author of the tool that can perform this task.

JM

0
Login to vote
Screenbert's picture

Something else you didn't put in there. Where do you need to run this from? A script or exe on the NS server? From your machine? From a web server on the NS server? The web server NOT on the NS server?

Depending on the answer there are some options for creating just such a program.

Screenbert

Screenbert

0
Login to vote
jasoncordell's picture

I would prefer that this was able to run on any workstation in the environment, preferable as an exe.

Also, I noticed that I added that the data should be pulled from DS, but that obviously should be NS, it was a long day.

0
Login to vote
Screenbert's picture

I should have something for you this week. You will be required to have the ASDK loaded on your NS server, but the ASDK will not be required on the client machines.

I've still got to add the following:
- Config file entry to hold search term (ie "Authorized")
- Config File entry to hold NS Server
- Config File entry to hold Default PC Domain name
- Catch Error if user is not authorized on NS Server
- Progress bar while loading/moving
- Logging Information

Things that will not be included in this version:
- Ability to import from a CSV File.
- Ability to open a helpdesk ticket. (I don't use the Altiris helpdesk solution so this one probably won't happen since I don't have anything to test against)

The end result will be a compiled executable using a mix of the ASDK, SQL queries using the ASDK and C#. I would include a screenshot, but alas you cannot attach screenshots to comments.

Screenbert

Screenbert

0
Login to vote
Screenbert's picture

Jason,

I've uploaded the ACST tool to Juice and it should be available soon. Let me know what you think of it, any issues or enhancements.

Thanks!

Screenbert

Screenbert

0
Login to vote
jasoncordell's picture

Thanks for the tool. This does a fantastic job. I truly appreciate your efforts since this will save me (and others) a great deal of time.

The one enhancement that I would like to see added is the ability to open an Altiris helpdesk incident.

This shouldn't be too hard since we can simply send an email and have an incident opened.

Thanks again for your help,
Jason

0
Login to vote
Screenbert's picture

Jason,

Glad the tool is working for you. I'll see about adding a check in there so that it will not return an un-managed computer.

I've been looking over the helpdesk options to add to this tool. I believe I can create a ticket, but I cannot test it against anything since I don't have the helpdesk solution loaded. I need some information.

1. Is there fieldName in the helpdesk ticket that specifies whether it is open/closed? If so what is the field name? What are the possible Values (open/closed/resolved?)
2. Do you want the ticket created and left open?
3. What other fields do you want information put in besides the Title and comments fields?

It may be a few weeks before I can do much with this as I'll be on Vacation for a couple of weeks.

Thanks,
Screenbert

Screenbert

0
Login to vote
jasoncordell's picture

Sorry for the delay on this.

I am still looking for info about the fieldnames. We have modified our DS imaging process to send an email to incidents@domain.com once the process is complete to have an incident created automatically. This is working fine, but someone has to modify the incident afterwards to set the asset, status, SCIM, etc.

Once I figure out how to identify these fields, and use them in helpdesk, I will pass this along to you.

FYI, I am using sendmail.vbs from http://www.myitforum.com/articles/5/view.asp?id=5341

Thanks,
Jason

0
Login to vote