Yes - remotesigned.

Tried the single server name in threee styles -

- SERVER\INSTANCE

- SERVER

- INSTANCE

and there is no difference in the execution. A log files gets created and...

Unfortunately not, the job just generates the log files. There are no csv files created or archived. apparently the first PS script doesnt begin, just the SS job log files...

Just to fill in some gaps since my last post (which appears to have started a heated debate!)...

When you have an problem with something you fix it with the tools...

Here is some code that does what i think you need in the sample database.

Hope it helps.

(Please note this uses the old methods to reference the system objects (syscolumns). From...

Probably not the best solution as i often think 'like a programmer' but...

cant you select the whole results into a temp table and then drop the first column then select...

Sounds like the media you (or the person at your Co., if its before your time...) used to install the server was on a Select license. check this out http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=295301

You...

Never had too much success with it but search BOL for "SERVERPROPERTY", there are loads of values that you can interrogate...

this shows the value you are after

SELECT CONVERT(CHAR(20),SERVERPROPERTY('licensetype'))

HTH

many apologies, i hadnt seen your two posts before mine.

I downloaded the files and copied them to the server - i didnt spot that the article was different. I have...

OK, SQLCMD isnt the big deal, I was trying to use that to debug why the job wast working...

any ideas on the reason that the csv files dont get generated,...

yup spotted that one pretty early on.

still not getting it to run from the job though. 🙁

SQLPSX_SMOtoCSV.log is empty

SQLPSX_CSVtoDB.log has:

Move-Item : Cannot create a file when that file already...

This is a great way to collect the security state of my servers. Took a bit of tinkering to get it all to work - i wanted the SQLPSX data...

yonision (2/29/2008)

---

There's a nice product that's using this exact technology, but already delivers everything to you with a nice GUI, easily viewable logs and all, and saves you all the...

Great example of something i have been wanting to implement for a long time.

Step 2 mentions 'attached SQL' but i cant see it, what am i doing wrong?

David, what tables do these reports query? what problem can running a select query against these tables cause?

Hi, there is a PK-FK link, its just not the same column name in both tables. I am on sick leave at the moment and cant get to a SQL...