Re: Automatic reports?

Mathias wrote:
Excellent, works beautifully. I've combined it with a vbscript that opens the webpage on a schedule which then saves the file to the harddrive. Thanks a lot.


"Kim Oppalfens [MVP]" <""Kim dot Oppalfens\"@google mail.com"> wrote in message news:uNPg1yi7HHA.5184@xxxxxxxxxxxxxxxxxxxxxxx
sherrylkissinger@xxxxxxxxx wrote:
I'm quite fortunate in that I have SQL experts in my company to do
this... but when we need data from 1 SQL database to be imported into
another, we just tell the SQL team--and those wizards figure it out.
I know it's somehow scheduled within SQL. I realize this information
is not extremely useful; but perhaps this will give you a different
direction to search. Instead of searching on "how to do this with
sms", perhaps "how to do this with sql" ? I am assuming that both
databases are within the same organization.

I know we have 1 routine setup like this. Our internal helpdesk
ticketting system (sql on the backend) pulls data from SMS to populate
the helpdesk systems' hardware tables and linking hardware to users.

If that is not an option, may I suggest the book "SMS 2003 Recipes" by
Greg Ramsey and Warren Byle? Page 267, topic 8-10 "Automatically
Exporting Report Results" sounds like exactly what you are looking
for.

On Sep 3, 4:24 am, "Mathias" <maha.nos...@xxxxxxxxx> wrote:
I'd like to schedule the generation of a report and get the output as a CSV
file. Is there a smart way to do this? My idea is to somehow get a vbscript
to ask the SQL-query and then save the result as a CSV-file. But perhaps
there's a smarter way?
The CSV file is going to be imported into another DB afterwards.

//Mathias


Sample:
http://tbe1ms3/SMSReporting_B01/Report.asp?ReportID=259&ExportTo=C:\temp\Report259.txt


Just replace the Url you want to run in the above line, modify the exportto value.

Schedule this url using scheduled tasks en internet explorer.

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx


I had a script lying around like that somewhere, but couldn't find it.
Would you mind sharing the script?
Does it close the Internet explorer window afterwards?

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx
.

Relevant Pages

  • Re: Automatic reports?
    ... I've combined it with a vbscript that opens the webpage on a schedule which then saves the file to the harddrive. ... we just tell the SQL team--and those wizards figure it out. ... ticketting system pulls data from SMS to populate ...
    (microsoft.public.sms.inventory)
  • Re: Automatic reports?
    ... we just tell the SQL team--and those wizards figure it out. ... ticketting system pulls data from SMS to populate ... Windows Server System MVP - SMS ... I had a script lying around like that somewhere, ...
    (microsoft.public.sms.inventory)
  • Re: SMS Provider fails to install on SQL server
    ... No SMS 2003 will not run on MSDE. ... IT will only run on standard and enterprise SQL. ... Configmgr support 64bit, named instances and clustered sql servers. ... Windows Server System MVP - SMS ...
    (microsoft.public.sms.installer)
  • Re: SMS Provider fails to install on SQL server
    ... sms is not supported on msde or sql 2005 express for that matter. ... Windows Server System MVP - SMS ... Configmgr support 64bit, named instances and clustered sql servers. ...
    (microsoft.public.sms.installer)
  • Re: Automatic reports?
    ... but when we need data from 1 SQL database to be imported into ... we just tell the SQL team--and those wizards figure it out. ... ticketting system pulls data from SMS to populate ... Schedule this url using scheduled tasks en internet explorer. ...
    (microsoft.public.sms.inventory)
Loading