Legato NetWorker Commands Index:ansrd
* - Windows Only
mminfomminfo - NetWorker media database reporting command
mminfo [ -avV ] [ -o order ] [ -s server ] [ -x exportspec ] [ report ] [ query ] [ volname... ] < report >: [ -m | -p | -B | -S | -X | -r reportspec ] < query >: [ -c client ] [ -l ] [ -N name ] [ -t time ] [ -q queryspec ]
The mminfo command reports information about NetWorker media and save sets. The mminfo command can produce several different reports depend- ing on the flags specified. Several built-in reports can be specified using short-hand flags. Custom reports can also be specified. The default report, along with the built-in reports printed by the use of the -v, -V, -m, -p, -S, -B, and -X flags, are described first below. The custom query and report generators, using the -q queryspec and -r reportspec options, are described in the CUSTOM QUERIES AND REPORTS section. Other options are described in the OPTIONS section. Without any options, mminfo displays information about the save sets that completed properly since the previous day's midnight, and are still contained in an on-line file index (browsable save sets). The following information is printed for each save set: the containing vol- ume name, the client's name, the creation date, the size saved on that volume, the save set level, and the save set name. The size field is displayed in Bytes (B), KiloBytes (KB), MegaBytes (MB), GigaBytes (GB), TeraBytes (TB), PetaBytes (PB), or ExaBytes (EB). The save set level will display 'full', 'incr', 'migration' or 1 through 9, for full, incremental, migration save sets, level 1 through 9, respectively. The level is only kept for scheduled saves and file migration; save sets generated by explicitly running the save(1) command (called ad hoc saves) do not have an associated level. Specifying the -v flag prints aborted, purged, and incomplete save sets in addition to the complete, browsable save sets printed by default. The -v flag also causes three additional fields to be displayed: the creation time, the internal save set identifier (ssid), and two flags. One character is used per flag. The first flag indicates which part of the save set is on the volume. When the save is completely contained on the volume, a c is displayed. An h is displayed when the save set spans volumes and the head is con- tained on this volume. The remaining sections will be on other vol- umes. An m is displayed when the save set spans volumes and a middle section is contained on this volume. The head and tail sections will be on different volumes. There may be more than one middle section. A t is displayed when the tail section of a spanning save set is con- tained on this volume. Again, the other sections will be on other vol- umes. The second flag indicates the status of the save set. A b indicates that the save set is in the on-line index and is browsable via the an NDMP save set. An R indicates a raw partition backup, eg., Networker Modules like Oracle, Sybase and others that Networker supports. It does not denote the save set contains files utilizing the rawasm direc- tive. A P indicates a snapshot save set. A The -V flag displays even more detail than the -v flag, and is gener- ally used for debugging. This format also displays information (such as, media file number and record number) that can be used to speed the operation of the scanner(1) command. Rather than displaying one line per save set per volume, three lines are displayed each time a section of a save set occurs within a file on a volume. A single save set will have multiple index entries if it starts in one file on a volume and ends in another. This report contains all of the information reported via the -v flag, but, because of the additional detail, some of this information is reordered. The first line will contain the volume name, the client's name, the size saved in that section, the save set level, and the save set name. The size field lists the number of bytes that are contained in the section, rather than the total amount of the save set on this volume. The second line contains the following fields: the internal save set identifier (ssid), the save time in seconds since 00:00:00 GMT, Jan 1, 1970, the creation data and time of day, the internal save set identifier (ssid), the browse time, and the retention time. The third line contains: the offset of the first and last bytes of the save set contained within section, the media file number, the first record within the media file containing data for this save set, the internal volume identifier (volid), the total size of the save set, and the flags, described in the -v paragraph above, indicating which part of the save set is contained in this media file (c, h, m, or t) and the save set's status (b, r, a, or i). The -p flag causes mminfo to display a report on the browse and reten- tion times for save sets. Each line of the report displays the save set creation date, and the stored browse and retention dates ('undef' is displayed when connecting to a downrev server), the save set identi- fier, the client's name, and the save set's name. The -v and -V options have no effect on the columns included in this report. The -m flag causes mminfo to display the name of each volume in the media database, the number of bytes written to it, the percent of space used (or the word 'full' indicating that the volume is filled to capac- ity), the retention (expiration) time, the number of bytes read, the number of times the read-label operation has been performed on the vol- ume (not the count of explicit mounts), and the volume's capacity. Volumes that are recyclable (see nsrim(1)) are flagged by an E in the first column (meaning Eligible for recycling). If a volume has been marked as manually-recyclable, an M is displayed instead of the E. If a volume is both manually-recyclable and eligible for recycling, an X will be displayed. Archive and migration volumes are flagged by an A, also in the first column. If the volume is not an archive or migration volume, and is not recyclable, no flag appears. Specifying the -v flag with the -m flag causes three additional fields to be displayed: the internal volume identifier (volid), the number of the next file to be written, and the type of media. Using a -V flag with the -m adds a column of flags to the output. There are currently two possible flags. The d flag is set if the vol- ume is currently being written (dirty). The r flag is set if the vol- attributes, described below. The first line of each multi-line group starts on the left margin and includes the save set identifier (ssid), save time as both a date/time string and seconds since 00:00:00 GMT, Jan 1, 1970, and the client and save set names. Subsequent lines for this save set are indented. If the save set is part of a save set series (a 'continued save set') and is not the first in the series, the save set identifier of the previous save set in the series in shown on the second line by itself. The next line displays the level, the save set flags (in 'ssflags' format, as described in the table in the CUSTOM QUERIES AND REPORTS section), the save set size in bytes, the number of files in the save set, and the save set insertion date. The next line displays the save set's create, completion, browse and retention (aka expiration) dates. The string 'undef' for any of the values on these two lines generally means an older server that does not store these values is being queried. If the client identifier is set, it is printed on the next line. If the save set has extended attributes (such as the group to which the save set was a part or the archive annotation), they are printed next, at most one attribute per line. The format of each extended attribute is "name: values;". The clones or instances of the save set are shown last (every save set has at least once instance). The first line of each clone shown the clone identifier, the date and time the instance was created, and the per- clone flags (in 'clflags' format from the CUSTOM QUERIES AND REPORTS table). For each instance, each section of that instance is shows as a fragment line. The fragment line shows the offset of that fragment from the beginning of the save set, the volume identifier (volid) con- taining the fragment, the media file and record numbers of start of the fragment, an absolute positioning identifier (unused by existing servers), and the date of last access of the fragment. The -v and -V options have no effect on this report. The -o sort order options o and m are ignored when -S is specified. The -X flag prepares a save set summary report instead of one or more lines per save set. Note that the entire media database must be exam- ined to resolve this query, making it very slow and expensive. If used in conjunction with the 'a' option, the query of all volumes is done to check for savesets. If used without the 'a' option, only saveset infor- mation in the last 24 hours, is considered. The summary lists the total number of save sets, and breaks the total down into several over- lapping categories summarizing the save set types. The recent save set usage, if appropriate to the query, is also printed. The categories are the number of fulls, the number of incrementals, the number of other non-full, non-incremental saves, the number of ad hoc, archive, migration, empty and purged save sets, the number of index save sets, and finally, the number of incomplete save sets. For recent usage, the number of save sets per day is shown, up to a week ago, along with a summary of the week's save sets and, if applicable, a summary of the month's save sets. For each line, the number of files (saved in the time interval specified), number of save sets, total size, average size per save set, and average size per file are listed. The percentage of the amount saved for incrementals versus fulls and the percentage of browsable files are also printed, when appropriate. The -v and -V options have no effect on the summary report. The -B flag performs a canned query to output, in a convenient format, the list of bootstraps generated in the previous five weeks. In this format, there is one line of output for each matched save set. Each line contains the save date and time, save level, save set identifier bined with a media-only report (-m or a custom report showing only media information), -a applies to all volumes, not just those with complete and browsable save sets. -c client Restricts the reported information to the media and/or save sets pertaining to the specified client. This is similar to specify- ing a client name using the queryspec (see -q option) name. In both cases the names are matched using a case insensitive string comparsion. If the reportspec (see -r option) includes volume, the reported information will include those pertaining to the aliases of the client. If information relating to the aliases of the client is not required in the output, when the reportspec includes volume, the -l option needs to be used in conjunction with -c client. -l This option when used with -c client along with reportspec (see -r option) containing volume, the output will not include all the information pertaining to the aliases of the specific client. -m Displays a media report instead of the default save set report (in other words, a report about the media containing save sets, not the save sets themselves). -N name Restricts the reported information to the media and/or save sets pertaining to the specified save set name. -o order Sorts the output in the specified order. Before displaying the save sets, they are sorted by various fields. Numeric fields are sorted least to greatest, other fields are sorted alphabeti- cally. order may be any combination of the letters celmnotR, representing client, expiration date, length, media name, name of save set, offset on media (file and record number), time, and Reverse, respectively. The default sorting order for save set reports is mocntl. The offset fields (file and record) are only considered when the -V option has been selected and for custom reports that show save set section (fragment) information. When applied to -m media-only reports, the length is the amount used on the volume, the time is the last time the media was accessed, and the other order flags are ignored. -q queryspec Adds the given query constraint to the list of constraints on the current query. Multiple -q options may be given. See the CUSTOM QUERIES AND REPORTS section below for the syntax of the queryspec. -r reportspec Appends the given report specification to the list of attributes to be displayed for the current query. Multiple -r options may be given. See the CUSTOM QUERIES AND REPORTS section below for the syntax of the reportspec. -s server Displays volume and save set information from the NetWorker sys- switches: -a, -B, -c, -N, -m, -o and -q. When using those switches, there is no default value for time. If you wish to see only the backups since yesterday, you will have to specify '-t yesterday' explicitly. -v Turns on the verbose display reports, described above. -x exportspec As an alternative to the default human-readable output format, exportspec provides for two styles of program-readable output formats. The exportspec 'm' displays XML output, while export- spec 'c<separator>' displays values separated by any single character. For example, 'mminfo -xc,' will produce comma-sepa- rated values. -B Runs the canned query to report bootstraps which have been gen- erated in the past five weeks, as described above. This option is used by savegrp(1) when saving the server's index and boot- strap. -S Displays a long, multi-line save set report, as described above. -V Displays additional verbose report output, as described above. -X Prepares a summary report, as described above.
CUSTOM QUERIES AND REPORTS
The custom query and report options of mminfo allow one to generate media and save set reports matching complex constraints without resort- ing to pipelines and scripts. This section describes the syntax of custom query and report specifications, and gives some simple examples. Further examples are shown in the EXAMPLES section, below. The custom query option, -q queryspec, is an extension to the short- hand query options, such as -c client, which allow you to make queries based on almost any media or save set attribute in the database, and allow various comparisons in addition to the simple equality comparison provided by the short-hand options. The format of a queryspec is [!] name [ comp value ] [ , ... ] where name is the name of a database attribute, listed in the table below, comp is a valid comparator for the attribute, from the set '>', '>=', '=', '<=', '<', and value is the value being compared. Leading and trailing spaces can be used to separate the individual components of the specification. The comparator and value must be specified for all but flag attributes. Generally numeric attributes allow all five comparators, and character string attributes generally only allow equality. When comparing flags whose values are normally 'true' and 'false', one may alternatively use the '[ ! ] name' syntax. The '!name' form is equivalent to 'name=false', and 'name' by itself is equivalent to 'name=true'. The comparisons in the specification are separated by commas. If a time or a string contains commas, you must quote the value with single or double quotes. Quotes are escaped within a string by repeating them. The following is a valid string comparison: name="Joe's daily, ""hot"" Save Set" short-hand query constraints -c, -N and -t. The order of the above query constraints is unimportant. Numeric constraints, except for identifiers (volume, save set and clone identifiers), allow ranges to be specified, and all character string constraints allow multiple possible values to be specified. Note that times and levels are considered to be numeric values, not character strings. The upper and lower bounds of a numeric range are specified as two separate constraints. For example, %used>20,%used<80 matches volumes that are between 20% and 80% used. All strings are also lists except 'attributes and volume attributes'. Each possible value of a given character string attribute is specified as a separate equality constraint. For example, client=pegasus,client=avalon matches save sets from the client 'pegasus' or the client 'avalon'. Example, if 'group' string attribute is used multiple times, the 'mminfo' query would be mminfo -av -q 'group=Default, group=Test' This would report savesets for both 'Default' and 'Test' groups. The custom report option, -r reportspec, allows one to specify exactly which media and save set attributes should be shown in the report, the order of the columns, the column widths, and where line breaks should be placed. The format of a reportspec is name [ (width) ] [ , name [ (width) ] ... ] where name is the name of a database attribute, listed below, and the optional width, enclosed in parentheses, specifies how wide the column should be. Leading and trailing spaces are ignored. The default col- umn width depends on the attribute; default widths are also shown in the table below. Multiple -r options may be specified. The order of the columns in the report will be left to right, and correspond to the order of the attribute names specified. Each line of output will con- tain all of the data requested (you can cause line breaks within a log- ical line by using the newline attribute name). If a value does not fit in the requested column width, subsequent values in the line will be shifted to the right (values are truncated at 256 characters). The table below lists all of the recognized attribute names, their valid range of query values (or 'NA' for attributes that are only valid for report specifications), their default column width in characters (or 'NA' for flag attributes that are only valid for query specifica- tions), and a short description. Numeric attributes (shown as number in the valid range column of the table) can be specified using any of the comparators listed above, and can be used in range comparisons. The =id attributes are used for various identifiers (volume identifier, constraints, and have corresponding flag summary strings for report specifications. Time attributes are specified in nsr_getdate(3) format and are other- wise treated as numeric attributes (note that you will need to quote times that contain commas). The special time 'forever', when used as an expiration date, means a save set or volume will never expire. The special time 'undef' is displayed when the time is undefined. When output, times are displayed according to local settings, usually as MM/DD/YY HH:MM:SS for numeric month, day year (last two digits), hours, minutes, and seconds, respectively. If the column is very narrow (less that 17 characters), only the date is shown. Columns 22 characters wide will generally print the full date. This is dependent on the for- mat reported by the operating system. If the returned date and time will not fit in the specified columns, only the date is shown. Size and kbsize attributes may have a scale factor appended to them: 'KB' for kilobytes, 'MB' for MegaBytes, 'GB' for GigaBytes, 'TB' for TeraBytes, 'PB' for PetaBytes, or 'EB' for ExaBytes. The default scale (when no scale is explicitly specified) on query constraints for attributes is bytes; the default for kbsize attributes is kilobytes. The scale varies in reports, depending on the actual value. String attributes may be any arbitrary character string, enclosed in quotes if necessary, as described above in the query syntax paragraph. attribute value name range width description space NA 1 White space before the next column. newline NA 1 Line break(s) within a logical line. Width is actually the number of newlines desired. volume string 15 The volume name. volid =id 11 The unique volume identifier. barcode string 15 The volume barcode, when set. family string 4 The media family (for example, tape, disk). type string 7 The media type (for example, 8mm, optical). volflags NA 5 Volume summary flags, d and r, for dirty (in use) and read-only. state NA 3 Volume state summary, E, M, X and A, meaning eligible for recycling, manually-recyclable, both, and archive or migration volumes, respectively. full flag NA Matches full volumes. inuse flag NA Matches in-use (dirty) volumes. volrecycle flag NA Matches recyclable volumes. readonly flag NA Matches read-only volumes. manual flag NA Matches manually-recyclable volumes. pool string 15 The pool containing the volume. location string 15 The volume's location. capacity size 8 The volume's estimated capacity. written kbsize 7 Kbytes written to volume. %used number 5 Estimated percentage used, or 'full' or 'full' for volumes marked as full. read kbsize 8 Kbytes read (recovered) from the volume. next number 5 Next media file for writing. nrec number 5 Next media record for writing. mounts number 6 Number of times the read-label operation is performed on the volume (not the count of explicit mounts). recycled number 4 Number of times the volume was relabeled. avail NA 3 Summary of volume availability, current valid values, n meaning nearline (that is, in a jukebox), and ov meaning the volume is being managed by SmartMedia. near flag NA Matches nearline volumes. smartmedia flag NA Matches volumes managed by SmartMedia. metric number 6 Volume speed and desirability metric (unused by existing servers). savesets NA 6 Number of save sets on a volume. volattrs NA 31 The extended volume attributes. name string 31 The save set name. savetime time 9 The save time (on the client). nsavetime NA 11 The save time, printed as seconds since 00:00:00 GMT, Jan 1, 1970. sscreate time 9 The creation time (on the server). If the client and server clocks are out of sync, this time may be different from the save time. ssid =id 11 The unique save set identifier. snap flag NA Display snapshot backups only. level 0..9, 5 The backup level. Manual backups full, incr, are printed as blank column migration values in reports. or manual client string 11 The client resource name associated with the host that was backed up in this save set. attrs NA 31 The extended save set attributes. pssid =id 11 When part of a save set series, the previous save set identifier in the series, zero for the first or only save set in a series. ssflags NA 7 The save set flags summary, one or more characters in the set CvrENiRPKIF, for continued, valid, purged (recoverable), eligible for recycling, NDMP generated, incomplete, raw(not for savesets backed up using rawasm), snapshot, cover, in-progress and finished (ended), respectively. continued flag NA Matches continued save sets. recoverable flag NA Matches recoverable (purged) save sets. ssrecycle flag NA Matches recyclable save sets. incomplete flag NA Matches incomplete save sets. rolledin flag NA Matches rolled-in save sets. ndmp flag NA Matches NDMP save sets. raw flag NA Matches raw save sets, containing partitions saved by NetWorker modules. valid flag NA Matches valid save sets. All save sets are marked 'valid' by current servers. sumflags NA 3 Per-volume save set summary flags, as described for the -v report. fragflags NA 3 Per-section save set summary flags, ssretent time 9 The save set's retention time (expiration time). This is the time limit that the save set will remain in the media database. ssinsert time 9 The save set's insertion time. This is the time the save set was most recently introduced into the database (for example, by a backup or by running scanner(1)). sscomp time 9 The save set's completion time. This is the time the save set backup was completed. clientid =id 9 The globally unique client identifier for the host that was backed up in this save set. copies number 6 The number of copies (instances or clones) of the save set, all with the same save time and save set identifier. cloneid =id 11 The clone identifier of one copy. clonetime time 9 The time a copy was made. clflags NA 5 The clone flags summary, one or more characters from the set ais for aborted, incomplete, suspect (read error), respectively. This summary reflects the status of an instance of a save set. suspect flag NA Matches suspect save set copies, copies that had errors during file recovery. annotation string 31 The (archive) save set's annotation. In a queryspec, the string is a regular expression in the form used by grep(1). group string 12 The group of this save set. This is the group that backed up this save set. first number 11 The offset of the first byte of the save set contained within the section. last NA 11 The calculated offset of the last byte of the save set contained within the current section. fragsize NA 7 The calculated size of the current section of the save set. sumsize NA 7 The calculated total size of all of the sections of the save set on this volume. mediafile number 5 The media file number containing the current section of the save set. mediarec number 5 The media record number where the first bytes of the save set are found within the current media file. mediamark number 5 The absolute positioning data for the current section (not used by existing servers). ssaccess time 9 The last time this section of the save set was accessed (for backup or recover).
In the following examples, the equivalent short-hand and custom ver- sions of the report are shown, when a short-hand option exists for a given report or query. Display all bootstraps generated in the previous five weeks, as reported by savegrp(1): mminfo -B Display media information from volumes mars.001 and mars.002: mminfo -m mars.001 mars.002 mminfo -m -q 'volume=mars.001,volume=mars.002' Display all save sets named /usr: mminfo -N /usr mminfo -q name=/usr Display save sets named /usr, generated by client venus, in the past week: mminfo -N /usr -c venus mminfo -q 'name=/usr,client=venus' Display save sets named /usr, generated by client venus, on volume mars.001: mminfo -N /usr -c venus mars.001 mminfo -q 'name=/usr,client=venus,volume=mars.001' Display a media report of all volumes written on in the past week: mminfo -m -t 'last week' mminfo -m -q 'savetime>=last week' Display a media report of all non-full volumes, showing the percent- used, pool and location of each volume: mminfo -a -r 'volume,%used,pool,location' -q '!full' Display a media report similar to the -m report but showing the barcode instead of the volume label: mminfo -a -r 'state,barcode,written,%used,read,space' -r 'mounts(5),space(2),capacity' Display a verbose list of the instances of all save sets with more than one copy, sorted by save time and client name: mminfo -otc -v -q 'copies>1' Display all archive save sets with an annotation of "project data" for the past four months. mminfo -q'annotation=project data' -r"volume,client,savetime,sumsize,ssid,name,annotation" -t'four months ago' Display all snapshot save sets for the client cyborg. mminfo -q'client=cyborg, snap' -r"volume,client,savetime,sumsize,ssid,name,annotation" -t'four months ago' NOTE: This option is available with Legato's PowerSnap Module only Display all snapshot save sets with their snapshot handle, for the client cyborg. The snapshot handle is stored in the attribute ┬┤*snapid┬┤. mminfo -a -S -q'client=cyborg, snap' -t'four months ago' NOTE: This option is available with Legato's PowerSnap Module only
A User with "Recover Local Data" privilege is allowed to query the media database for save set information only for the client where privilege to be able to access save set information. The "Remote Access" privilege can be granted either through "the "Remote access all clients" privilege or through the "Remote access" attribute in client resource. A user with "Monitor Networker" privilege can query the media database for volume and save set information for any client. This is equivalent to having both "Operate Devices and Jukeboxes" and "Remote Access" privileges.
/nsr/mm/mmvolume6 The save set and media volume databases (actually accessed by nsrmmdbd(1)).
grep(1), nsr_getdate(3), nsr_layout(5), nsradmin(1), nsrmmdbd(1), recover(1), savegrp(1), scanner(1).
no matches found for the query No save sets or volumes were found in the database that matched all of the constraints of the query. invalid volume name 'volname' The volume name given is not in a valid format. Note that vol- ume names may not begin with a dash. Queries that match no vol- umes will return the error 'no matches found for the query'. only one of -m, -B, -S, -X or -r may be specified Only one report can be generated at a time. Use separate runs of mminfo to obtain multiple reports. invalid sorting order specifier, choose from 'celmnotR' Only letters from celmnotR may be used with the -o option. only one -o allowed Only one sorting order may be specified. only one -s allowed Only one server can be queried at one time. Use multiple runs of mminfo to obtain reports from multiple servers. Out of Memory The query exhausted available memory. Try issuing it again, using the sorting order -om, or make the query more restrictive (for example, list specific volumes, clients, and/or save set names). invalid value specified for 'attribute' The value specified is either out of range (for example, a nega- tive number for a value that can only take positive numbers), the wrong type (an alphabetic string value specified for a numeric attribute), or just poorly formatted (for example, non- blank characters between a close quote and the next comma or a missing close quote). value of 'attribute' is too long The value specified for attribute is longer than the maximum unknown query constraint: attribute The given query attribute is not valid. See the CUSTOM QUERIES AND REPORTS table for a list of all valid attribute names. need a value for query constraint 'attribute' The attribute is not a flag, and must be specified in the 'name comparator value' format. constraint 'attribute' is only valid for reports The attribute specified for a query may only by used in report (-r) specifications. Calculated values, flag summaries, save set extended attributes, and formatting tools (space and new- line) may not be used in queries. invalid comparator for query constraint 'attribute' The comparator used is not valid for the given attribute. See the CUSTOM QUERIES AND REPORTS section for a list of the valid comparators for attribute. query constraint 'attribute' specified more than once The given attribute was specified more than once with the same comparator, and is not a string attribute (string attributes can match one of several specific values). unknown report constraint: attribute The given report attribute is not valid; see the CUSTOM QUERIES AND REPORTS table for a list of all valid attribute names. constraint 'attribute' is only valid for queries The attribute specified for a report is a flag matching attribute and may only be used in query (-q) specifications. See the CUSTOM QUERIES AND REPORTS table for the appropriate flag summary attribute that one may use in reports of a given flag. column width of 'attribute' is invalid The width specified for attribute is out of range. Column widths must be positive numbers less than 256. missing close parenthesis after report constraint 'attribute' The width of attribute is missing a close parenthesis. missing comma after report constraint 'attribute' There are non-blank characters after the width specification for attribute without any comma preceding them. No data requested, no report generated The given report specification contains only formatting, no data attribute names.
You cannot specify save set extended attributes as query constraints. You cannot list several possible equality matches for numbers, only for strings. Some queries, namely those that are not highly selective (few query You cannot specify query constraints that compare database attributes with each other. You cannot make a report that uses -B flag with -c flag.
ADVERTISEMENTLegato NetWorker 7.x
Man(1) output converted with man2html, sed, awk