Query issue

[ticklz]

After you have successfully run a query, say what pcs have 3.x version of acrobat on them, for example, and got the result of the query. How do you output this onto paper? How do i extract this info from SQL into a printable format?

Thanks in advance
Lola Who's that girl!

 

[Calgarian]

I'm assuming that you're talking about the SMS admin console.

> Select query in left hand pane.
> Click right mouse button.
> Select Export List...
> Select .csv or .txt formats and save.

 

[ticklz]

Ripple, mine doesnt have the 'export list' option ... and when i use smsquery.xls, im getting application-defined or object-defined error...

<sigh> Who's that girl!

 

[Calgarian]

You need to get MMC v1.2.

You can get it from:

http://download.microsoft.com/download/platformsdk/Utility/1.2/W9X2K/EN-US/IMMC.EXE

Sorry, I haven't worked out how to make the link active yet!

 

[ticklz]

Ripple,

I might as well direct all my queries to you! 2nd time to my rescue... Thanks. It worked perfectly.

I appreciate it.

Lola. Who's that girl!

 

[Calgarian]

Glad I could help you.