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

  • 7754505
  • 02-Feb-2007
  • 01-Oct-2010

Environment

AppManager 6.0.2

Situation

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

Resolution

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



Additional Information

Formerly known as NETIQKB54505

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


Feedback service temporarily unavailable. For content questions or problems, please contact Support.