Workflow and ServiceDesk Community

Hello ,

I am currently adotping the 'Symantec Zero Day' patch worflow to existing process in my company.  At certain stage, let's say after the pilot phase, I need to disable the bulletins that potentially caused issues before moving to the production stage.

I am looking for the way to disable the bulletin, provided I have the bulletin's guid or name. The disabled bulletin is not distributed to the package servers. I reviewed the ASDK webservices methods as well as Workflow components. The closest I found is the disable policy method. But it is not what I  am looking for.

I also used the Altiris Profiler to trace the SQL. The stored procedure that seems to do the trick is:

 EXECUTE spItemActiveSave @Guid='Guidofbulletintobedisabled', @Enabled=0, @KeepExisting=0

I could use it in the intergration library. But really I doubt it is enough ?. It changes the status from 'Yes' to 'No'  in the Downloaded colument in Remediation Center but I doubt I will disable the corresponding policies and advertisements the same way as when you do the disable action in the console UI.

Thank you in advance for any hints.

Tomasz

Hello Tomasz,

The ItemActive table is the place to target, and yes, if you set its value to no (0 really) to a policy item, that policy will be disabled. 

SK.

Hi Scott,

Thanks for the reply.

I tested it and it still does not work for me. Here are the replication steps.

1. Stage bulletin

2. Disable bulletin whether manually or with ItemActive table

3. Run the Symantec Zero Day Workflow. 

New policy is created even the bulletin is disabled :(

I investigated it and looks like the 'IsStaged' method from http://NS/Altiris/PatchManagementCore/PatchWorkflowSvc.asmx webservice returns 'True' for disabled bulletin because there are available package for the given bulletin.

Apperently I have to use more radical method such as

Deleteitem from http://localhost/Altiris/ASDK.NS/ItemManagementService.asmx ​webservice, to get rid of the bulletin and prevent from creating a new policy for it.

Unless there are some other ideas how to disable bulletin so it is displayed as not downloaded and corresponding number of packages is 0.

Thanks

Tomasz

Could you adjust the Workflow project to include a custom component that checks the patch package status for you?  Then it could filter out the bulletins that are actually included in the process based on whatever criteria you're looking at.

For example, just run a simple SQL query to determine whether a bulletin is disabled in this model:

It looks like within that model, there are already some filter components being used (for whether policies exist and whether it's staged), so I'm not sure how your staged bulletins are being sorted in that model, but maybe just do some debugging in the workflow to determine where the process isn't working for you, and make adjustments in the Workflow instead of trying to shape the data items themselves around the existing workflow logic.  

I'll be glad to help with Webex if you need.