How can I extract the data for a specific knowledge script and machine from the repository (NETIQKB54505)

How can I extract the data for a specific knowledge script and machine from the AppManager repository?

The following SQL Statement will allow data for a specified knowledge script and machine to be extracted from the ArchiveData table in the AppManager repository.  Replace the values NT_CPULoaded and SERVER01 with the desired knowledge script name and server name, respectively:

select ADH.KPName as Knowledge_Script,
 ADH.HiddenLegend,
 Dateadd(second,AD.Time,'1/1/1970 0:0:0') as Time,
 Dateadd(second,AD.BiasedTime,'1/1/1970 0:0:0') as BiasedTime,
 AD.Value
from ArchiveData AD
Inner Join ArchiveDataHeader ADH
 on AD.DataID = ADH.DataID
 where ADH.KPName like '%NT_CPULoaded%'
  and ADH.MachineName = 'SERVER01'
Order by BiasedTime Asc

Formerly known as NETIQKB54505

If you need further assistance with the subject matter discussed in this Knowledge Base Article, please contact NetIQ Technical Support.