Sure, Thank you.

It is tablix.

Ok Alan,

Now I am able to understand the script little bit. It gets all the attributes from the XML file.

SELECT

ObjectName AS PackageName,

...

Yes Alan, I am collecting the metadata information same as in the Jamie Thompson's post advised.

When I say that running in different machines, I meant that running in cross...

Thank you Phil...It seems I need to get that in XML format and get the info as like as you said

Hi Miranda,

Thanks for the information. Just curious...Can we do everything on share point that we do on report manager? like subscription and data driven subscription?

Thank you Phil, you gave me an idea

but Just curious...Is there a way to get it on the GO?

Like we get the below informations....Just curious...through vb/c# coding?

FileInfo fileinfo;

...

I am collecting the attributes of a dtsx file. Is there a way to collect the owner of the package or 'who created it' information?

Thank you, Pietlinden

Yes I am using a parameter to filter the reports. All the time, it is going to be a SP but in case if any reports are using direct query,...

;WITH XMLNAMESPACES (

DEFAULT ''http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'',

''http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'' AS rd --ReportDefinition

)

SELECT

CreatedBy

,CreationDate

,ModifiedBy

,ModifiedDate

,NAME

,PATH

,x.value (''@Name'', ''VARCHAR(100)'') AS ReportParameterName

,x.value (''DataType[1]'', ''VARCHAR(100)'') AS DataType

,x.value (''AllowBlank[1]'', ''VARCHAR(50)'') AS AllowBlank

,x.value (''Prompt[1]'', ''VARCHAR(100)'') AS Prompt

,x.value (''Hidden[1]'', ''VARCHAR(100)'') AS Hidden

,x.value (''data(DefaultValue/Values/Value)[1]'',...

Hi Pietlinden,

I noticed that all the reports are logged by default in the SQL server. Is that possible to get the source query from any of the logging tables? I...

I have not set any page options or tablix properties. Do I have to ?

Thank you for...

Yes Luis...Now I understood. So based on the starting day, we are calculating it. I get it.

Thank you Luis. I appreciate your time.