This post is more than 5 years old
11 Posts
0
1042
December 3rd, 2008 07:00
StorageScope Custome Queries duplicate lines for FLR data
Hi,
I have noticed that when I run the following via storagescope after collecting FLR data I get duplicate entries for certain files i.e
Last Accessed (GMT+00:00) Last Modified (GMT+00:00) File Name Parent Directory File Name Extension Owner Actual Size (Bytes)
2005-10-18 23:18 2005-02-17 15:00 FEST2_ORACLE_HOME.tar /fest/oracle4/backup/ TAR orafest 2556707840
2005-10-18 23:18 2005-02-17 15:00 FEST2_ORACLE_HOME.tar /fest/oracle4/backup/ TAR orafest 2556707840
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
My main query is filtering on the following ( note without VXFS clause I am getting 12 entries per file )
Hosts.Host Name equal to and files.last Accessed before and file systems.File system Type equal to VXFS.
I have taken a look at the server and have seen that the permissions on the parent directory are 777 now I can also see that the file is then seen as being owned by both the file owner and also the parent which is why I am getting duplicates. Does anyone know how to work around this?
I have noticed that when I run the following via storagescope after collecting FLR data I get duplicate entries for certain files i.e
Last Accessed (GMT+00:00) Last Modified (GMT+00:00) File Name Parent Directory File Name Extension Owner Actual Size (Bytes)
2005-10-18 23:18 2005-02-17 15:00 FEST2_ORACLE_HOME.tar /fest/oracle4/backup/ TAR orafest 2556707840
2005-10-18 23:18 2005-02-17 15:00 FEST2_ORACLE_HOME.tar /fest/oracle4/backup/ TAR orafest 2556707840
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
2008-11-18 23:10 2006-10-11 12:15 exp.tar /fesi/opt/oracle/admin/CAT/EXPORT/ TAR allan 201040384
My main query is filtering on the following ( note without VXFS clause I am getting 12 entries per file )
Hosts.Host Name equal to and files.last Accessed before and file systems.File system Type equal to VXFS.
I have taken a look at the server and have seen that the permissions on the parent directory are 777 now I can also see that the file is then seen as being owned by both the file owner and also the parent which is why I am getting duplicates. Does anyone know how to work around this?
No Events found!
seamuscoffey
472 Posts
0
January 8th, 2009 07:00
The fix for CQ365877 was Patch 4212 which was a Host Agent patch (all platforms). It upgrades the host agent build to 6.0.0.0.359 as you have stated below.
The contents of the Engineering CQ ticket simply root cause the original issue (duplicate entries in SRMFile) and then deliver the fix via 4212.
Regards,
Séamus
seamuscoffey
472 Posts
0
December 3rd, 2008 07:00
I created the following Knowledgebase article a few months ago re StorageScope duplicate rows:
emc191617: ControlCenter 6.0 StorageScope: Duplicate rows appear in StorageScope custom query results.
Hope it helps....
Regards,
Séamus
AllanMc
11 Posts
0
December 3rd, 2008 08:00
I had seen the primus case also , I was looking at filtering however there isnt a key/field I can see for permissions of a given file where I could have filtered on where the perms were not 777 in the owners.owner field. I am wondering if I could do this and add unique constraints etc on the filename within crystal reports instead or I need to take the file onto a unix server and sort -u it.
Al
AllanMc
11 Posts
0
January 8th, 2009 03:00
I thought by reading the following it may have resolved my issue but its not I was wondering what it was resolving.
4212 6.0.0.0.359 Modify the agent code so that duplicate file
entries are eliminated from the scanned data.
As a result there won't be any duplicates in
the SRMFile table and reports will be
accurate.
365877