select isnull((select min(Severity) from DPMDB_vw_DPM_Alerts where ResolvedTime is null),9) as 'Status'
<?xml version="1.0" encoding="UTF-8"?> <ValueLookup id="oid.microsoft.dpm.status" desiredValue="9" undefinedState="Warning" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PaeValueLookup.xsd"> <Lookups> <SingleInt state="Warning" value="1"> Avertissement </SingleInt> <SingleInt state="Ok" value="9"> Ok </SingleInt> <SingleInt state="Error" value="0"> Erreur </SingleInt> </Lookups> </ValueLookup>