cancel
Showing results for 
Search instead for 
Did you mean: 

ePO Database RSD Index Missing?

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])

 


2 Replies
exbrit
Level 21
Report Inappropriate Content
Message 2 of 3

Re: ePO Database RSD Index Missing?

Moved to ePO for faster support

---

Peter

Moderator

andrep1
Level 14
Report Inappropriate Content
Message 3 of 3

Re: ePO Database RSD Index Missing?

Missing in his opinion ? I don't think that index exists out of the box, based on a check I did on my server.

When you install, update, upgrade ePO or a product in ePO everything is scripted including everything related to the database. Adding an index manually might make one of those operations fail.

I don't think McAfee would like that you added an index...