2 Replies Latest reply on Nov 17, 2015 11:02 AM by andrep1

    ePO Database RSD Index Missing?

    robby07

      Hello,

       

      Recently we reviewed the ePO database (ePO 5.1.2) with our dba.  The dba recommended that the below index be added to a RSD table as it will enhance the querying of the database.  He said that it was missing.  Have anyone seen this?  We have several ePO servers and it is "missing" on each of them.  

       

      CREATE INDEX RSDDetectedSystemProperties_NetbiosName_DetectionType ON [ePO_Database].[dbo].[RSDDetectedSystemProperties] ([NetbiosName], [DetectionType]) INCLUDE ([HostID], [DnsName], [Domain], [LastDetectedTime])