Hi, i need to find CM12 application (deployment type) source paths. select ContentSourcePath from fn_ListApplicationCIsWithLatestTime(1033) returns empty values in my environment. 

I tried Select name,pkgsourcepath from v_package and i does return applications data as well but pkgsourcepath is empty for applications as well.

Check powershell cmdlet's but couldn't see content location in get-cmdeploymenttype.

Appreciate your suggestions in advance!

I think the data can be also exported from the xml data that's stored in the database, more info on that here:

http://blogs.technet.com/b/hhoy/archive/2012/07/19/how-to-query-configuration-manager-2012-xml-data-with-sql-xquery.aspx

...but I think this is exactly what you're looking for:

http://anoopcnair.com/2012/05/07/configmgr-sccm-2012-custom-reports-for-list-of-applications-deployment-types-and-content-source/

• Proposed as answer by narcoticoo 15 hours 52 minutes ago
• Marked as answer by anuragyadav 4 hours 43 minutes ago