1 Copper

Re: Non-Compliant Systems not displayed

Would anyone from Dell care to publish an SQL script I can run against my OME DB to fix the broken [Catalog].[usp_DeviceApplicablePackages] stored procedure? I have found the problem to be within the "FilteredServerPackages" portion of that procedure and edited out the filtering, which restored my non-compliant system display. So I'm wondering what exactly that part of the query is filtering because my list of non-compliant devices is accurate now?! Cheers!