How I make a multiple exclusion pattern?

Mikhail_Scherbakov

Good afternoon, colleagues!

My task is to make a multiple exclusion pattern. Read how to do it in the User-Guide-Asset-Mgt-SW-Assets.docx.

«10. Create Bundles

• If you need multiple exclusion patterns or software patterns to narrow the related assets into one line item, create a Bundle.
• If you are only entering multiple exclusion patterns, you just enter the same software pattern, but different exclusion patterns to remove all the unwanted software names.»

I did it according to the manual, but instead of the extra “MUI” and “Proof” packages disappeared, the number counted by Microsoft Office 2007 is doubled.

For some reason it does not work as described in the manual. Please help me!

damon_mulligan

If you are attempting to just create a consolidated Microsoft Office 2007, to include Microsoft Office Enterprise 2007 and Microsoft Office Professional Plus 2007, all you have to do is put those 2 exactly as they are displayed in the SW Pattern in the bundle.

Bundle

Software Pattern                                         Version Pattern
Microsoft Office Enterprise 2007                  12.%
Microsoft Office Professional Plus 2007        12.%

damon_mulligan

Yes, that is correct. Use the following SQL Query run against the ServiceManagement DB to compare Software CI's to HW Assets. You can then easily export to Excel and see if you are missing anything.

------------------------------------------------- Beginning of Script---------------------------------------------------- 

select si.DisplayName, Publisher_CC606490_641D_5F83_AC59_088C7E706264 Publisher, VersionString_AF0E8942_772E_7C25_5EFE_B21D6E2E41CE VersionString

, sa.DisplayName, sa.Version_68BCD8CB_C968_8996_C8B0_B8027BEA4E3D Version

, sa.SoftwarePattern_EFE53D27_E963_E8E8_C103_7E7CC629E72C SoftwarePattern, sa.VersionPattern_F93DB089_5C2E_04F2_AB06_8B021B8E9003 VersionPattern

from dbo.MTV_System$SoftwareItem si

   inner join dbo.BaseManagedEntity bme on bme.BaseManagedEntityId = si.BaseManagedEntityId and bme.IsDeleted = 0

   left outer join dbo.Relationship rel on rel.TargetEntityId = bme.BaseManagedEntityId and rel.RelationshipTypeId = '78d316fc-5f12-c4a0-fefa-973759594e87'

   left outer join dbo.MTV_Cireson$AssetManagement$SoftwareAsset sa on sa.BaseManagedEntityId = rel.SourceEntityId

order by 1, 2

------------------------------------------------- End of Script---------------------------------------------------- 

damon_mulligan

Thank you for bringing this to our attention. We will update the guide to eliminate any confusion. There are not many scenarios where you would need multiple exclusion patterns. By entering them this way the first pattern includes everything except %Proof%, but the 2nd pattern includes everything except %MUI% which includes proof. 

Just like the way Subscriptions should be built, where you use include or Equals instead of Does Not Equal in the Criteria, you must approach the SW Pattern the same way. Please attach an export to excel the filtered Office 2007 Software CI's and highlight the ones you want to include. I will show you what SW Patterns to use, that will probably not need exclusion patterns.

Mikhail_Scherbakov

Hello Damon! Thanks for the answer. I send the file you requested. Thanks again for help.

Mikhail_Scherbakov

I'm sorry. For some reason the file is not attached. Attached again.

damon_mulligan

Sent private email, please email directly to me.

Mikhail_Scherbakov

Hello Damon! Maybe I should create a ticket on the support site?

damon_mulligan

If you are attempting to just create a consolidated Microsoft Office 2007, to include Microsoft Office Enterprise 2007 and Microsoft Office Professional Plus 2007, all you have to do is put those 2 exactly as they are displayed in the SW Pattern in the bundle.

Bundle

Software Pattern                                         Version Pattern
Microsoft Office Enterprise 2007                  12.%
Microsoft Office Professional Plus 2007        12.%

Mikhail_Scherbakov

Yes, it works. But if there is a new office package appear, what to do then? Each time, analyze the appearance of new packages and add new package definitions to bundle?

damon_mulligan

Yes, that is correct. Use the following SQL Query run against the ServiceManagement DB to compare Software CI's to HW Assets. You can then easily export to Excel and see if you are missing anything.

------------------------------------------------- Beginning of Script---------------------------------------------------- 

select si.DisplayName, Publisher_CC606490_641D_5F83_AC59_088C7E706264 Publisher, VersionString_AF0E8942_772E_7C25_5EFE_B21D6E2E41CE VersionString

, sa.DisplayName, sa.Version_68BCD8CB_C968_8996_C8B0_B8027BEA4E3D Version

, sa.SoftwarePattern_EFE53D27_E963_E8E8_C103_7E7CC629E72C SoftwarePattern, sa.VersionPattern_F93DB089_5C2E_04F2_AB06_8B021B8E9003 VersionPattern

from dbo.MTV_System$SoftwareItem si

   inner join dbo.BaseManagedEntity bme on bme.BaseManagedEntityId = si.BaseManagedEntityId and bme.IsDeleted = 0

   left outer join dbo.Relationship rel on rel.TargetEntityId = bme.BaseManagedEntityId and rel.RelationshipTypeId = '78d316fc-5f12-c4a0-fefa-973759594e87'

   left outer join dbo.MTV_Cireson$AssetManagement$SoftwareAsset sa on sa.BaseManagedEntityId = rel.SourceEntityId

order by 1, 2

------------------------------------------------- End of Script---------------------------------------------------- 

Mikhail_Scherbakov

Thanks! Good luck Damon!