How about XML\RSS format for Reporting?

Need new test, action, option? Post request here.
Post Reply
mpriesss

How about XML\RSS format for Reporting?

Post by mpriesss »

Hi Alex,

How about an option to have reports saved in .XML format? Maybe this would allow us to set up RSS feeds that would allow end-users to "subscribe" to services, processes, etc that affect their business and only monitor and receive the reports\statistics for them. Instead of an admin needing to create many different reports this would allow the end-user to take on the responsibility or just provide the admin more flexibiliy to share hostmonitors data with other web applications more efficiently. I suppose this can be done with the data already if ODBC logging is used but having it built in to the app would be great too. I don't know if any other monitoring app that does this. Yet, another way to differentiate your product from the competition. Which you already have done with a low price\great product combination. :-)

Take Care,
Mark
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

I am not sure XML reports will be implemented in version 4.xx. Most likely it will be done in version 5.

Regards
Alex
rasqual0

Post by rasqual0 »

Count me in on this idea. This is exactly what we want -- the ability to subscribe to an RSS feed from hostmon.

The sooner this is implemented, the sooner we'll be on cloud 9. We've considered creating this ourselves!
colstripcom
Posts: 31
Joined: Mon Sep 27, 2004 7:34 am

Post by colstripcom »

Any update if XML reports will be available?
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Sorry, built-in XML report style is not implemented.
But you may implement it by yourself using Custom HTML report mode: http://www.ks-soft.net/hostmon.eng/mfra ... CustomHTML

Regards
Alex
dsi
Posts: 9
Joined: Sun Sep 14, 2003 7:56 pm

custom html mode xml report

Post by dsi »

I have something like what Alex suggested...

This is very long, and only works if you do not have any reserved charicters in your test name, and may not be fully complaint, etc, etc, but it does parse with VB.NET xml opjects and that was all I really was worried about. Unless I missed some, or some have been recently added, this should contain every macro variable that can be used in a report, even the ones that only work for certian tests, so expect some empty values on some tests. It is NOT Rss, I found Rss to be too limited a structure for what I was trying to do, but it should show you how to make the references to create a Rss version if you wanted. Your results may vary, but this should get you started.

Instructions:

Go to report profiles screen and create a new report (I called mine xml). Select all the checkboxes in the status filter and include methods lists. Choose a report type of custom HTML then click the tool button to the right of the dropdown. When the html template screen pops up you will need to go through all the tabs and selections and clear them, replacing their content with the following:

Under header paste the following:

<?xml version="1.0" encoding="utf-8"?>
<result xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Date>%Date%</Date>
<Time>%Time%</Time>
<DateTime>%DateTime%</DateTime>
<TotalTests>%TotalTests%</TotalTests>
<GoodTests>%GoodTests%</GoodTests>
<BadTests>%BadTests%</BadTests>
<UnknownTests>%UnknownTests%</UnknownTests>
<DisabledTests>%DisabledTests%</DisabledTests>
<WaitForMasterTests>%WaitForMasterTests%</WaitForMasterTests>
<OutOfScheduleTests>%OutOfScheduleTests%</OutOfScheduleTests>
<folders>

under folder title paste the following:

<folder>
<Folder>%Folder%</Folder>
<FullPath>%FullPath%</FullPath>
<FolderAverage_AliveTime>%FolderAverage_AliveTime%</FolderAverage_AliveTime>
<FolderAverage_DeadTime>%FolderAverage_DeadTime%</FolderAverage_DeadTime>
<FolderAverage_UnknownTime>%FolderAverage_UnknownTime%</FolderAverage_UnknownTime>
<FolderAverage_AliveRatio>%FolderAverage_AliveRatio%</FolderAverage_AliveRatio>
<FolderAverage_DeadRatio>%FolderAverage_DeadRatio%</FolderAverage_DeadRatio>
<FolderAverage_UnknownRatio>%FolderAverage_UnknownRatio%</FolderAverage_UnknownRatio>
<FolderAverage_PassedTests>%FolderAverage_PassedTests%</FolderAverage_PassedTests>
<FolderAverage_FailedTests>%FolderAverage_FailedTests%</FolderAverage_FailedTests>
<FolderAverage_UnknownTests>%FolderAverage_UnknownTests%</FolderAverage_UnknownTests>
<FolderMin_MinReply>%FolderMin_MinReply%</FolderMin_MinReply>
<FolderMax_MaxReply>%FolderMax_MaxReply%</FolderMax_MaxReply>
<FolderAverage_AverageReply>%FolderAverage_AverageReply%</FolderAverage_AverageReply>
<FolderAverage_MinReply>%FolderAverage_MinReply%</FolderAverage_MinReply>
<FolderAverage_MaxReply>%FolderAverage_MaxReply%</FolderAverage_MaxReply>
<FolderTotal_PassedTests>%FolderTotal_PassedTests%</FolderTotal_PassedTests>
<FolderTotal_FailedTests>%FolderTotal_FailedTests%</FolderTotal_FailedTests>
<FolderTotal_UnknownTests>%FolderTotal_UnknownTests%</FolderTotal_UnknownTests>
<FolderTotal_SummarizedReply>%FolderTotal_SummarizedReply%</FolderTotal_SummarizedReply>
<FolderCurrent_TotalTests>%FolderCurrent_TotalTests%</FolderCurrent_TotalTests>
<FolderCurrent_GoodTests>%FolderCurrent_GoodTests%</FolderCurrent_GoodTests>
<FolderCurrent_BadTests>%FolderCurrent_BadTests%</FolderCurrent_BadTests>
<FolderCurrent_UnknownTests>%FolderCurrent_UnknownTests%</FolderCurrent_UnknownTests>
<tests>

under every status option under test items paste the following:

<test>
<Testproperties>
<TestName>%TestName%</TestName>
<HostName>%HostName%</HostName>
<HostID>%HostID%</HostID>
<TestID>%TestID%</TestID>
<Agent>%Agent%</Agent>
<TestMethod>%TestMethod%</TestMethod>
<Interval>%Interval%</Interval>
<Interval_Sec>%Interval_Sec%</Interval_Sec>
<Interval_Min>%Interval_Min%</Interval_Min>
<ScheduleName>%ScheduleName%</ScheduleName>
<AlertProfile>%AlertProfile%</AlertProfile>
<AlertThreshold>%AlertThreshold%</AlertThreshold>
<MasterTest>%MasterTest%</MasterTest>
<PrivateLog>%PrivateLog%</PrivateLog>
<RelatedURL>%RelatedURL%</RelatedURL>
<TaskComment>%TaskComment%</TaskComment>
<CommentLine1>%CommentLine1%</CommentLine1>
<CommentLine2>%CommentLine2%</CommentLine2>
<CommentID>%CommentID%</CommentID>
<Folder>%Folder%</Folder>
<FullPath>%FullPath%</FullPath>
<FolderComment>%FolderComment%</FolderComment>
<CreatedTime>%CreatedTime%</CreatedTime>
<ModifiedTime>%ModifiedTime%</ModifiedTime>
</Testproperties>

<Currentteststate>
<DATE>%DATE%</DATE>
<TIME>%TIME%</TIME>
<DateTime>%DateTime%</DateTime>
<LastTestTime>%LastTestTime%</LastTestTime>
<Reply>%Reply%</Reply>
<Reply_CStyle>%Reply_CStyle%</Reply_CStyle>
<Reply_Number>%Reply_Number%</Reply_Number>
<Reply_Integer>%Reply_Integer%</Reply_Integer>
<Status>%Status%</Status>
<StatusID>%StatusID%</StatusID>
<SimpleStatus>%SimpleStatus%</SimpleStatus>
</Currentteststate>

<Previousstate>
<LastStatus>%LastStatus%</LastStatus>
<LastReply>%LastReply%</LastReply>
<LastReply_CStyle>%LastReply_CStyle%</LastReply_CStyle>
<PreviousStatus>%PreviousStatus%</PreviousStatus>
<PreviousStatusTime>%PreviousStatusTime%</PreviousStatusTime>
<PreviousStatusDuration>%PreviousStatusDuration%</PreviousStatusDuration>
<PreviousStatusDuration_Sec>%PreviousStatusDuration_Sec%</PreviousStatusDuration_Sec>
</Previousstate>

<Statisticalinformation>
<Recurrences>%Recurrences%</Recurrences>
<StatusChangedTime>%StatusChangedTime%</StatusChangedTime>
<StatusChangesCnt>%StatusChangesCnt%</StatusChangesCnt>
<TotalTests>%TotalTests%</TotalTests>
<TotalTime>%TotalTime%</TotalTime>
<FailedCnt>%FailedCnt%</FailedCnt>
<PassedCnt>%PassedCnt%</PassedCnt>
<UnknownCnt>%UnknownCnt%</UnknownCnt>
<AliveTime>%AliveTime%</AliveTime>
<DeadTime>%DeadTime%</DeadTime>
<UnknownTime>%UnknownTime%</UnknownTime>
<AliveRatio>%AliveRatio%</AliveRatio>
<DeadRatio>%DeadRatio%</DeadRatio>
<UnknownRatio>%UnknownRatio%</UnknownRatio>
<AverageReply>%AverageReply%</AverageReply>
<MinReply>%MinReply%</MinReply>
<MaxReply>%MaxReply%</MaxReply>
</Statisticalinformation>

<Testspecificmacrovariables>
<HostAddr>%HostAddr%</HostAddr>
<ServiceComp>%ServiceComp%</ServiceComp>
<ServiceName>%ServiceName%</ServiceName>
<TraceBrief>%TraceBrief%</TraceBrief>
<TraceFull>%TraceFull%</TraceFull>
<NTEventSource>%NTEventSource%</NTEventSource>
<NTEventComp>%NTEventComp%</NTEventComp>
<NTEventTime>%NTEventTime%</NTEventTime>
<NTEventType>%NTEventType%</NTEventType>
<NTEventID>%NTEventID%</NTEventID>
<NTEventText>%NTEventText%</NTEventText>
<NTEventUser>%NTEventUser%</NTEventUser>
<TrapHost>%TrapHost%</TrapHost>
<TrapType>%TrapType%</TrapType>
<TimeTicks>%TimeTicks%</TimeTicks>
<Enterprise>%Enterprise%</Enterprise>
<MibOid>%MibOid%</MibOid>
<MibType>%MibType%</MibType>
<MibValue>%MibValue%</MibValue>
<MibRelative>%MibRelative%</MibRelative>
<MibRelative>%MibRelative%</MibRelative>
</Testspecificmacrovariables>
</test>

Under Folder summary paste the following:

</tests></folder>

under gap between folders paste nothing

under footer paste the following:

</folders></result>

end instructions...

there would be some minor advatages to having this be built in (like being able to use some of the reserved charicters in test names and results) but this gets me close enought for my purposes that I would not see it as a priority for Alex. If anyone has suggestions on how to make this more xml complaint without having to correct the individual tests I would love to hear them.
mkaeckel
Posts: 1
Joined: Fri Feb 08, 2008 8:44 am

Post by mkaeckel »

KS-Soft wrote:I am not sure XML reports will be implemented in version 4.xx. Most likely it will be done in version 5.

Regards
Alex
Is it possible now?
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Post by KS-Soft Europe »

mkaeckel wrote:Is it possible now?
Sorry, built-in XML reports have not been implemented yet. However, you may use "Custom HTML" report and template, suggested by dsi above.

Regards,
Max
rasqual
Posts: 11
Joined: Thu Jan 06, 2005 8:06 pm

Post by rasqual »

bump

:D
Post Reply