Re: Automatic reports?

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

.

Relevant Pages

  • Re: Automatic reports?
    ... 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. ... Windows Server System MVP - SMS ...
    (microsoft.public.sms.inventory)
  • 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)
  • Re: Scheduling DTS Packages on 64-bit SQL Server
    ... My understanding is that DTS components are not available for 64-bit SQL ... > I found the following comment on Microsoft's website in regards to scheduling> a DTS package on a 64-bit SQL Server installation. ... do I need> to buy a 32-bit copy of SQL Server to store my packages on to be able to> schedule them? ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • SQL error
    ... I am attempting to permit the user to select 1 of 3 options in the display of database records. ... OptSchedule(0) is titled: ... The SQL statement worked before I included the sSchedule variable also. ... strSQL = "SELECT LastName, FirstName, ClientID, " ...
    (comp.lang.basic.visual.misc)
Loading