do you have ready made SQL create script for 2008 r2 version ?
( could find from help)
do you have ready made MS report server reports for all similar report
like html report ? (
)esko
MS sql script
MS sql script
hi
do you have ready made SQL create script for 2008 r2 version ?
( could find from help)
do you have ready made MS report server reports for all similar report
like html report ? ()
esko
do you have ready made SQL create script for 2008 r2 version ?
( could find from help)
do you have ready made MS report server reports for all similar report
like html report ? (
)esko
"SQL create script? What exactly should perform this script?"
good question, I missed one word "table"
create table , something like this , to get all fields and format correct associated to test result ..
there is model INSERT of #testresults to database..
this is example :
GO
/****** Object: Table [dbo].[Attachment] Script Date: 06/14/2013 16:46:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tests](
[timestamp] [timestamp] NOT NULL,
[No_] [int] NOT NULL,
[Attachment] [image] NULL,
[Storage Type] [int] NOT NULL,
[Storage Pointer] [varchar](250) NOT NULL,
[File Extension] [varchar](250) NOT NULL,
[Read Only] [tinyint] NOT NULL,
[Last Date Modified] [datetime] NOT NULL,
[Last Time Modified] [datetime] NOT NULL,
[Store Pointer ID] [image] NULL,
[Store Pointer Checksum] [int] NOT NULL,
[Entry Pointer ID] [image] NULL,
[Entry Pointer Checksum] [int] NOT NULL,
CONSTRAINT [Attachment$0] PRIMARY KEY CLUSTERED
(
[No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [Data Filegroup 1]
) ON [Data Filegroup 1] TEXTIMAGE_ON [Data Filegroup 1]
GO
SET ANSI_PADDING OFF
GO
good question, I missed one word "table"
create table , something like this , to get all fields and format correct associated to test result ..
there is model INSERT of #testresults to database..
this is example :
GO
/****** Object: Table [dbo].[Attachment] Script Date: 06/14/2013 16:46:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tests](
[timestamp] [timestamp] NOT NULL,
[No_] [int] NOT NULL,
[Attachment] [image] NULL,
[Storage Type] [int] NOT NULL,
[Storage Pointer] [varchar](250) NOT NULL,
[File Extension] [varchar](250) NOT NULL,
[Read Only] [tinyint] NOT NULL,
[Last Date Modified] [datetime] NOT NULL,
[Last Time Modified] [datetime] NOT NULL,
[Store Pointer ID] [image] NULL,
[Store Pointer Checksum] [int] NOT NULL,
[Entry Pointer ID] [image] NULL,
[Entry Pointer Checksum] [int] NOT NULL,
CONSTRAINT [Attachment$0] PRIMARY KEY CLUSTERED
(
[No_] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [Data Filegroup 1]
) ON [Data Filegroup 1] TEXTIMAGE_ON [Data Filegroup 1]
GO
SET ANSI_PADDING OFF
GO
Still do not understand your question.
Yes, you can use CREATE TABLE SQL command to create table. What this has to do with HostMonitor?
You need script that will create HTML reports similar to standard HostMonitor reports using some MS SQL database? Using data from ODBC log created by HostMonitor?
What is wrong with built-in reports?
Or you don't need HTML reports?
Do you want to create table with some statistical information using HostMonitor ODBC log as input data?
Regards
Alex
Yes, you can use CREATE TABLE SQL command to create table. What this has to do with HostMonitor?
You need script that will create HTML reports similar to standard HostMonitor reports using some MS SQL database? Using data from ODBC log created by HostMonitor?
What is wrong with built-in reports?
Or you don't need HTML reports?
Do you want to create table with some statistical information using HostMonitor ODBC log as input data?
Regards
Alex
hi,
all reports are ok . no fails on those.
Basically I can do script myself, just asking if You had ready already...
the last sentence is quite correct :
"Do you want to create table with some statistical information using HostMonitor ODBC log as input data?"
I want to put "test results" = "log data" to MS SQL Database as statistical database and use tools like Qlikview or MS Reporting services to report it out.
We done little extra , like "business process monitoring" with Hostmonitor .
We do odbc sql test to ERP database and want share that infomation in ad-hoc reporting tools or in Crystal reports .. KPI's like How many invoices and how many order we can check easily with HM, because it has scheduling and functionality to do this. (and 1000 times cheaper as "best in class" BPM softwares)
Thru external tool and MS SQL we can deliver data to other people as IT department..
all reports are ok . no fails on those.
Basically I can do script myself, just asking if You had ready already...
the last sentence is quite correct :
"Do you want to create table with some statistical information using HostMonitor ODBC log as input data?"
I want to put "test results" = "log data" to MS SQL Database as statistical database and use tools like Qlikview or MS Reporting services to report it out.
We done little extra , like "business process monitoring" with Hostmonitor .
We do odbc sql test to ERP database and want share that infomation in ad-hoc reporting tools or in Crystal reports .. KPI's like How many invoices and how many order we can check easily with HM, because it has scheduling and functionality to do this. (and 1000 times cheaper as "best in class" BPM softwares)
Thru external tool and MS SQL we can deliver data to other people as IT department..
H'm, no, we don't have script for you. Script or even simple Select query depends on what exactly data do you need, what fields do you store in the log...Basically I can do script myself, just asking if You had ready already...
This is a little bit strange task for HostMonitor. Its suppose to be network monitoring softwareWe do odbc sql test to ERP database and want share that infomation in ad-hoc reporting tools or in Crystal reports .. KPI's like How many invoices and how many order we can check easily with HM, because it has scheduling and functionality to do this. (and 1000 times cheaper as "best in class" BPM softwares)
Regards
Alex
ok,
when I get sql script ready, then I'll put it here...
"this is a little bit strange task for HostMonitor. Its suppose to be network monitoring software "
yes, it's strange from Hostmonitor point of view, agreed.
But when creating operative IT systems and same time I have to make
tools to monitor process for example "collect payment file for bank and send it by ftp to bank". This process I define to Hostmonitor :
1) is there a file to send ( HM :file count < 1 in certain time in folder 'output')
2) is bank IP line open ( HM: ping and login url success)
3) run ftp ( no HM task)
4) is there a file send after ftp ( HM: file count > 0 in certain time in folder 'output') IF this gives error then business process does not work and I can do it manually.
lets close this case for a while.
br,
esko
[quote="KS-Soft"][quote]Basically I can do script myself, just asking if You had ready already... [/quote]
H'm, no, we don't have script for you. Script or even simple Select query depends on what exactly data do you need, what fields do you store in the log...
[quote]We do odbc sql test to ERP database and want share that infomation in ad-hoc reporting tools or in Crystal reports .. KPI's like How many invoices and how many order we can check easily with HM, because it has scheduling and functionality to do this. (and 1000 times cheaper as "best in class" BPM softwares)[/quote]
This is a little bit strange task for HostMonitor. Its suppose to be network monitoring software
Regards
Alex[/quote]
when I get sql script ready, then I'll put it here...
"this is a little bit strange task for HostMonitor. Its suppose to be network monitoring software "
yes, it's strange from Hostmonitor point of view, agreed.
But when creating operative IT systems and same time I have to make
tools to monitor process for example "collect payment file for bank and send it by ftp to bank". This process I define to Hostmonitor :
1) is there a file to send ( HM :file count < 1 in certain time in folder 'output')
2) is bank IP line open ( HM: ping and login url success)
3) run ftp ( no HM task)
4) is there a file send after ftp ( HM: file count > 0 in certain time in folder 'output') IF this gives error then business process does not work and I can do it manually.
lets close this case for a while.
br,
esko
[quote="KS-Soft"][quote]Basically I can do script myself, just asking if You had ready already... [/quote]
H'm, no, we don't have script for you. Script or even simple Select query depends on what exactly data do you need, what fields do you store in the log...
[quote]We do odbc sql test to ERP database and want share that infomation in ad-hoc reporting tools or in Crystal reports .. KPI's like How many invoices and how many order we can check easily with HM, because it has scheduling and functionality to do this. (and 1000 times cheaper as "best in class" BPM softwares)[/quote]
This is a little bit strange task for HostMonitor. Its suppose to be network monitoring software
Regards
Alex[/quote]
create table sql
Here is model, no index yet,
******
USE [dbtests]
GO
/****** Object: Table [dbo].[Host_Monitor] Script Date: 06/26/2013 10:52:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Host_Monitor](
[Test_time] [datetime] NULL,
[Test_Name] [varchar](50) NULL,
[Test_id] [int] NULL,
[Test_Method] [varchar](50) NULL,
[Test_Status] [varchar](50) NULL,
[Test_Reply] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
******
USE [dbtests]
GO
/****** Object: Table [dbo].[Host_Monitor] Script Date: 06/26/2013 10:52:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Host_Monitor](
[Test_time] [datetime] NULL,
[Test_Name] [varchar](50) NULL,
[Test_id] [int] NULL,
[Test_Method] [varchar](50) NULL,
[Test_Status] [varchar](50) NULL,
[Test_Reply] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO