Query SIMS db for DocStorage file names etc

dm.sql

SELECT
	docType		= dt.[description]
	,fileName	= d.attachment_name
	,Name		= d.summary
	,Note		= d.note
	,LastModDt	= d.last_modification_date
	,Type		= et.[description]
	,Status		= s.[description]
	,Username	= u.[login_name]
	,Name		= p.[forename] + ' ' + p.[surname]
FROM
	[sims].[dm_document_710] d
	left outer join [sims].[dm_document_doctype] dt on
		d.[document_type_id] = dt.[lookup_value_id]
	left outer join [sims].[dm_document_entity_type] et on
		d.[entity_type_id] = et.[lookup_value_id]
	left outer join [sims].[dm_document_status] s on
		d.[document_status_id] = s.[lookup_value_id]
	left outer join [sims].[db_user] u on
		d.[created_by_id] = u.[user_id]
	left outer join [sims].[sims_person] p on
		u.[person_id] = p.[person_id]
WHERE
	d.attachment_name is not null