Solved
Duplicates in custom report
Just creating a simple report to show me all the tapes that allocated in the last 7 days.
Created a custom report
1. Name = Tape Reporting
2. Field Selection - Media Cartridge Label and Device Name
3. Set filters - Media Type Name = 'LTO' AND Date Allocated IN LAST 7 DAYS
4. No Grouping
5. Sort by Media Cartridge Label
No when I click on Preview it is perfect:
Note that this is returning only 7 rows. The preview is limited to 10 rows, but I there not that many fitting the filter. The preview is correct. Now when I run the actual report I get duplicate rows:
I get 14 pages of duplicate rows showing different devices.
Why is the report not matching the preview?
Thanks for any help.
Created a custom report
1. Name = Tape Reporting
2. Field Selection - Media Cartridge Label and Device Name
3. Set filters - Media Type Name = 'LTO' AND Date Allocated IN LAST 7 DAYS
4. No Grouping
5. Sort by Media Cartridge Label
No when I click on Preview it is perfect:
Media Cartridge Label
Device Name
CK8186L4
CK8187L4
FCTL01
CK8188L4
FCTL01
CK8192L4
FCTL01
CK8193L4
FCTL01
CK8195L4
FCTL01
CK8196L4
FCTL01
Note that this is returning only 7 rows. The preview is limited to 10 rows, but I there not that many fitting the filter. The preview is correct. Now when I run the actual report I get duplicate rows:
Media Cartridge Label
Device Name
CK8186L4
CK8186L4
CK8186L4
CK8186L4
CK8186L4
CK8186L4
CK8186L4
CK8186L4
CK8186L4
I get 14 pages of duplicate rows showing different devices.
Why is the report not matching the preview?
Thanks for any help.
- Hello,
http://support.veritas.com/docs/329045
Backup Exec 12.5 for Windows Servers revision 2213 Hotfix 329045
HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec For Windows\Backup
Exec\Server\
Value Name: ReportDistinctRecords
Value Type: DWORD
Value: 0 to disable, 1 to enable adding the 'distinct' keyword to reports.
Hope this helps !!!
