topic Syntax for dfm database query statement in Active IQ Unified Manager Discussions

Syntax for dfm database query statement

bhirscho — Thu, 05 Jun 2025 06:05:44 GMT

We need a way to get the objCreationTime out of DFM for volumes. Would someone please be able to provide the correct “dfm database query run “select”” statement?

Re: Syntax for dfm database query statement

adaikkap — Wed, 10 Apr 2013 05:30:38 GMT

Hi Bryan,

The field you are looking for ""objCreationTime" is not availabe via database views so you can access them using dfm database query run.

dfm detail <obj-name-or-id> | findstr /i obj will give your objCreation time.

C:\>dfm detail 17989 | findstr /i obj

objComment

objCreationTimestamp 2010-09-09 20:55:06.000000

objDeleted

objDeletedBy

objDisappearedSince

objFlags 5

objFullName xxx-drp01-cf1:/xxxx_project01

objId 17989

objName xxx_project01

objPerfStatus Unknown

objPerfStatusCode 5

objStaleSince

objStatus Error

objStatusChangeTimestamp 2012-01-15 09:43:34.000000

objStatusCode 7

objStatusMessage

objStatusTimestamp 2012-01-15 09:43:34.000000

objType Volume

sysObjectID .1.3.6.1.4.1.789.2.3

C:\>

Regards

adai

Re: Syntax for dfm database query statement

bhirscho — Wed, 10 Apr 2013 15:47:04 GMT

Thank you Adai,

My customer has thousands of volumes and was really hoping to query the database against this attribute, filtering on values older than some date "X". I believe your solutions will require exporting a list of all obj-name-or-id's then running the dfm detail command against each of them.

Can you think of any more efficient ways to accomplish this? Your help is appreciated.

Re: Syntax for dfm database query statement

jakob_scheidler — Thu, 25 Apr 2013 20:23:48 GMT

Hello,

don't know if you have solved this already. By querying against the DFM database and not the views, you are able to get this information.

eg: dfm query run "SELECT * FROM DFM.volumes v LEFT JOIN DFM.objects o ON v.volId = o.objId WHERE o.objDeleted IS NULL AND v.snapshotSourceId=0"

You just have to chose which fields you need for the output. SELECT * comes up with quite a lot fields which you probably don't need. If you need filernames and other you'd have to make more joins.

Hope this helps.

Regards

Re: Syntax for dfm database query statement

adaikkap — Fri, 26 Apr 2013 04:23:38 GMT

Hi Jakob,

dfm query run is not a supported cli and shouldn't not be used. Customer can only use view by dfm database query run cli.

Regards

adai