Idea ID: 1767018

MS SQL Management Pack - Add option to not allow MP deleting instances in RTSM

Status : Waiting for Votes
Waiting for Votes
See status update history
over 2 years ago

MP is removing the Ci  Instance and its sub-components in RTSM when we unassign the discovery policy from the node.

Would it be possible to add some flexibility in the management pack by makes adding an option to not allow  the removal of instances triggered by the agent ?

In our context, instances are imported in RTSM from our internal CMDB. We don't want to have them deleted by the MP.

  • Hello Florian, We've tested the filter in a more granulare scale but it didn't prevent the instance from being removed in RTSM. Here is the mapping we did:

    <?xml version="1.0" encoding="UTF-8"?>
    <Mapping xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../schemas/mapping.xsd">
        <!-- CONFIGURE THE CIs THAT DEFINES THE CONTEXT FOR THE MAPPING -->
        <Rules>
            <Rule name="Filter DBSPI SQL Server Service Elements">
                <Condition>
                    <And>
                        <Equals>
                            <OMType />
                            <Value>mssql_instance</Value>
                        </Equals>
                        <Exists>
                            <DependencyCI relationType="hosted_on">
                                <True />
                            </DependencyCI>
                        </Exists>
                                    <Not>
                                                   <IsDeletionCI />
                                   </Not>
                    </And>
                </Condition>
                <MapTo>
                    <Context>DBSPIMSSQL</Context>
                </MapTo>
            </Rule>
        </Rules>
    </Mapping>

     

     Best regards, Françoise

  • Hi,

    you can already disable the deletion of CIs by the discovery server (this does not affect deletion through CMDB sync) globally on the server since many releases:

    Infrastructure Setting:

    Operations Management - OM Topology Synchronization Settings 

    Skip CI Deletion

    Skip CI Deletion Disables (true) automatic deletion of CI when performing topology synchronization. CI deletion responsibility is transferred to RTSM CI ageing

     

    Even if you want to configure it on a more granular scale, you can do so by creating a respective topology sync mapping rule to filter out the deletion of CIs.

    Please let us know if this addresses your requirement. If not, please describe what is missing.

    Best regards,

    Florian