Column that provides Count of Properties with Values

[klark1kent]

I'd like to ask if it's possible to add a column that provides a total count of a file or folders Properties.

One reason I find think this would be useful is ...

I find I often open the Add Column window, manually adding the Preview Column, just to review / compare what metadata or file properties exist for certain file types. I use it to cross reference what data might populate in certain columns to more easily configure File Explorer, I've used it for other tools for things like tagging photos with EXIF data, because it's been useful to discover what Canonical Name Properties are exposed through the Everything Properties or the Windows Property System. I think it could be beneficial to quickly sort by a column with this information as instead of adding every single column you might need when running a search, you could leverage it to sort by the files that contain the most completed fields, adding all of those in one swoop, encompassing most of the files with less metadata or in reverse identify files that are missing metadata, etc.

It appears we already have access to an obscene amount of fields that populate each time we open the Add Column interface so I have to believe there is a mechanism to aggregate the total fields for a file that are populated with a value (or not populated with values).

In a nutshell, basically take the data from Add Column interface, count fields with values, and provide access to that data through a column in the search interface.

[void]

A total property value count would be extremely slow.

I'll consider a total property value count property.
I'll also consider a search function to search all properties.

I have on my TODO list to create a property dialog to show all the properties (kind-of like add columns -> Preview), set property values, reindex properties etc..

Thank you for the suggestions.

[klark1kent]

I appreciate your quick response and sounds good to me.

I'll counter by posing another question as to if total property value count would be less resource intensive if forced to be limited to only being accessible within folders or a specific folder, another option is potentially following similar guidance to some of the other slow functions, such as, max-count: or content: or binary but with a hard coded maximum search result. i.e. you can add this column but your search result would be throttled at 1000 files or something forcing a user to add more filters or dial in on specific search tasks.

[void]

I'll consider throttling and max counts.
Thank you for the suggestions.


The following might be helpful:

Shows all property values in Column 1:

Code: Select all

addcolumns:column1 column1:=TEXTJOIN(",",true,$35mm-focal-length:,$album:,$album-artist:,$alignment-requirement:,$allocation-size:,$alternate-data-stream-ansi:,$alternate-data-stream-count:,$alternate-data-stream-hex:,$alternate-data-stream-names:,$alternate-data-stream-text-plain:,$alternate-data-stream-utf-16:,$alternate-data-stream-utf-16be:,$alternate-data-stream-utf-8:,$altitude:,$aperture:,$artist:,$aspect-ratio:,$attributes:,$audio-bit-rate:,$audio-bits-per-sample:,$audio-channels:,$audio-format:,$audio-sample-rate:,$authors:,$author-url:,$available-free-disk-size:,$beats-per-minute:,$binary-type:,$bit-depth:,$brightness:,$byte-offset-for-partition-alignment:,$byte-offset-for-sector-alignment:,$byte-order-mark:,$camera-maker:,$camera-model:,$camera-serial-number:,$case-sensitive-dir:,$category:,$character-count:,$character-encoding:,$child-count:,$child-count-from-disk:,$child-file-count:,$child-file-count-from-disk:,$child-folder-count:,$child-folder-count-from-disk:,$child-occurrence-count:,$child-size:,$cluster-size:,$color-representation:,$column-0:,$column-1:,$column-2:,$column-3:,$column-4:,$column-5:,$column-6:,$column-7:,$column-8:,$column-9:,$column-a:,$column-b:,$column-c:,$column-d:,$column-e:,$column-f:,$comment:,$company:,$composer:,$compressed-bits-per-pixel:,$compressed-size:,$compression:,$compression-chunk-shift:,$compression-cluster-shift:,$compression-format:,$compression-ratio:,$compression-unit-shift:,$computer:,$conductor:,$container-file-count:,$container-filenames:,$content:,$content-created:,$content-provider:,$content-status:,$content-type:,$contrast:,$copyright:,$crc-32:,$crc-64:,$custom-property-0:,$custom-property-1:,$custom-property-2:,$custom-property-3:,$custom-property-4:,$custom-property-5:,$custom-property-6:,$custom-property-7:,$custom-property-8:,$custom-property-9:,$date-accessed:,$date-acquired:,$date-changed:,$date-created:,$date-indexed:,$date-modified:,$date-printed:,$date-received:,$date-recently-changed:,$date-released:,$date-run:,$date-saved:,$date-sent:,$date-taken:,$day-accessed:,$day-created:,$day-modified:,$delete-pending:,$descendant-count:,$descendant-file-count:,$descendant-folder-count:,$description:,$digital-zoom:,$dimensions:,$director:,$display-full-path:,$display-name:,$document-content-type:,$drive-type:,$effective-physical-bytes-per-sector-for-atomicity:,$encoded-by:,$encryption-status:,$end-of-file:,$exif-version:,$exposure-bias:,$exposure-program:,$exposure-time:,$extension:,$extension-frequency:,$extension-length:,$file-id:,$file-list-filename:,$file-list-full-path:,$filename-length:,$filename-utf-8-byte-length:,$file-signature:,$file-storage-info-flags:,$file-system:,$file-system-flags:,$first-128-bytes:,$first-16-bytes:,$first-256-bytes:,$first-2-bytes:,$first-32-bytes:,$first-4-bytes:,$first-512-bytes:,$first-64-bytes:,$first-8-bytes:,$first-byte:,$flash-energy:,$flash-maker:,$flash-mode:,$flash-model:,$focal-length:,$folder-depth:,$frame-count:,$frame-rate:,$free-disk-size:,$from:,$f-stop:,$full-path:,$full-path-length:,$full-path-utf-8-byte-length:,$genre:,$group-description:,$hard-link-count:,$hard-link-filenames:,$height:,$hidden-slide-count:,$horizontal-resolution:,$host-url:,$icon:,$image-id:,$incur-seek-penalty:,$index-number:,$index-type:,$index-volume-label:,$initial-key:,$is-directory:,$is-folder:,$iso-speed:,$kind:,$language:,$last-128-bytes:,$last-16-bytes:,$last-256-bytes:,$last-2-bytes:,$last-32-bytes:,$last-4-bytes:,$last-512-bytes:,$last-64-bytes:,$last-8-bytes:,$last-author:,$last-byte:,$latitude:,$length:,$lens-maker:,$lens-model:,$light-source:,$line-count:,$links-dirty:,$logical-bytes-per-sector:,$longitude:,$machine-target:,$maker-note:,$manager:,$max-aperture:,$max-child-depth:,$maximum-component-length:,$md5:,$md5sum-md5:,$md5sum-pass:,$media-created:,$metering-mode:,$mood:,$name:,$name-frequency:,$note-count:,$offline-availability:,$offline-status:,$online:,$opened-by:,$orientation:,$original-filename:,$out-of-date:,$owner:,$page-count:,$paragraph-count:,$parental-rating:,$parental-rating-reason:,$parent-file-id:,$parent-name:,$parent-path:,$parse-full-path:,$parse-name:,$part-of-a-compilation:,$part-of-set:,$path:,$path-length:,$people:,$perceived-type:,$period:,$photometric-interpretation:,$physical-bytes-per-sector-for-atomicity:,$physical-bytes-per-sector-for-performance:,$plain-text-line-count:,$presentation-format:,$producer:,$product-name:,$product-version:,$promotion-url:,$protected:,$publisher:,$randomize:,$rating:,$referrer-url:,$regular-expression-match-0:,$regular-expression-match-1:,$regular-expression-match-2:,$regular-expression-match-3:,$regular-expression-match-4:,$regular-expression-match-5:,$regular-expression-match-6:,$regular-expression-match-7:,$regular-expression-match-8:,$regular-expression-match-9:,$regular-expression-matches-1-9:,$related-sound-file:,$remote-protocol:,$remote-protocol-flags:,$remote-protocol-version:,$reparse-tag:,$reparse-target:,$resolution-unit:,$revision-number:,$root-name:,$row:,$run-count:,$saturation:,$scale:,$sector-size:,$sfv-crc-32:,$sfv-pass:,$sha-1:,$sha1sum-pass:,$sha1sum-sha-1:,$sha-256:,$sha256sum-pass:,$sha256sum-sha-256:,$sha-384:,$sha-512:,$sha512sum-pass:,$sha512sum-sha-512:,$shared-with:,$sharpness:,$shell-attributes:,$shortcut-target:,$short-full-path:,$short-name:,$shutter-speed:,$sibling-count:,$sibling-file-count:,$sibling-folder-count:,$size:,$size-frequency:,$size-on-disk:,$slide-count:,$software:,$stem:,$stem-length:,$subject:,$subject-distance:,$subtitle:,$tags:,$template:,$thumbnail:,$time-accessed:,$time-created:,$time-modified:,$title:,$to:,$total-alternate-data-stream-size:,$total-alternate-data-stream-size-on-disk:,$total-bit-rate:,$total-disk-size:,$total-editing-time:,$total-size:,$total-size-on-disk:,$track:,$trademarks:,$transcoded-for-sync:,$type:,$url:,$used-disk-size:,$valid-utf-8:,$version:,$version-number:,$vertical-resolution:,$video-bit-rate:,$video-format:,$volume-label:,$volume-name:,$volume-path:,$volume-serial-number:,$white-balance:,$width:,$word-count:,$writer:,$year:,$zone-id:)

Shows the total property value count in Column 1:

Code: Select all

addcolumns:column1 column1:=ELEMENTCOUNT(TEXTJOIN(",",true,$35mm-focal-length:,$album:,$album-artist:,$alignment-requirement:,$allocation-size:,$alternate-data-stream-ansi:,$alternate-data-stream-count:,$alternate-data-stream-hex:,$alternate-data-stream-names:,$alternate-data-stream-text-plain:,$alternate-data-stream-utf-16:,$alternate-data-stream-utf-16be:,$alternate-data-stream-utf-8:,$altitude:,$aperture:,$artist:,$aspect-ratio:,$attributes:,$audio-bit-rate:,$audio-bits-per-sample:,$audio-channels:,$audio-format:,$audio-sample-rate:,$authors:,$author-url:,$available-free-disk-size:,$beats-per-minute:,$binary-type:,$bit-depth:,$brightness:,$byte-offset-for-partition-alignment:,$byte-offset-for-sector-alignment:,$byte-order-mark:,$camera-maker:,$camera-model:,$camera-serial-number:,$case-sensitive-dir:,$category:,$character-count:,$character-encoding:,$child-count:,$child-count-from-disk:,$child-file-count:,$child-file-count-from-disk:,$child-folder-count:,$child-folder-count-from-disk:,$child-occurrence-count:,$child-size:,$cluster-size:,$color-representation:,$column-0:,$column-1:,$column-2:,$column-3:,$column-4:,$column-5:,$column-6:,$column-7:,$column-8:,$column-9:,$column-a:,$column-b:,$column-c:,$column-d:,$column-e:,$column-f:,$comment:,$company:,$composer:,$compressed-bits-per-pixel:,$compressed-size:,$compression:,$compression-chunk-shift:,$compression-cluster-shift:,$compression-format:,$compression-ratio:,$compression-unit-shift:,$computer:,$conductor:,$container-file-count:,$container-filenames:,$content:,$content-created:,$content-provider:,$content-status:,$content-type:,$contrast:,$copyright:,$crc-32:,$crc-64:,$custom-property-0:,$custom-property-1:,$custom-property-2:,$custom-property-3:,$custom-property-4:,$custom-property-5:,$custom-property-6:,$custom-property-7:,$custom-property-8:,$custom-property-9:,$date-accessed:,$date-acquired:,$date-changed:,$date-created:,$date-indexed:,$date-modified:,$date-printed:,$date-received:,$date-recently-changed:,$date-released:,$date-run:,$date-saved:,$date-sent:,$date-taken:,$day-accessed:,$day-created:,$day-modified:,$delete-pending:,$descendant-count:,$descendant-file-count:,$descendant-folder-count:,$description:,$digital-zoom:,$dimensions:,$director:,$display-full-path:,$display-name:,$document-content-type:,$drive-type:,$effective-physical-bytes-per-sector-for-atomicity:,$encoded-by:,$encryption-status:,$end-of-file:,$exif-version:,$exposure-bias:,$exposure-program:,$exposure-time:,$extension:,$extension-frequency:,$extension-length:,$file-id:,$file-list-filename:,$file-list-full-path:,$filename-length:,$filename-utf-8-byte-length:,$file-signature:,$file-storage-info-flags:,$file-system:,$file-system-flags:,$first-128-bytes:,$first-16-bytes:,$first-256-bytes:,$first-2-bytes:,$first-32-bytes:,$first-4-bytes:,$first-512-bytes:,$first-64-bytes:,$first-8-bytes:,$first-byte:,$flash-energy:,$flash-maker:,$flash-mode:,$flash-model:,$focal-length:,$folder-depth:,$frame-count:,$frame-rate:,$free-disk-size:,$from:,$f-stop:,$full-path:,$full-path-length:,$full-path-utf-8-byte-length:,$genre:,$group-description:,$hard-link-count:,$hard-link-filenames:,$height:,$hidden-slide-count:,$horizontal-resolution:,$host-url:,$icon:,$image-id:,$incur-seek-penalty:,$index-number:,$index-type:,$index-volume-label:,$initial-key:,$is-directory:,$is-folder:,$iso-speed:,$kind:,$language:,$last-128-bytes:,$last-16-bytes:,$last-256-bytes:,$last-2-bytes:,$last-32-bytes:,$last-4-bytes:,$last-512-bytes:,$last-64-bytes:,$last-8-bytes:,$last-author:,$last-byte:,$latitude:,$length:,$lens-maker:,$lens-model:,$light-source:,$line-count:,$links-dirty:,$logical-bytes-per-sector:,$longitude:,$machine-target:,$maker-note:,$manager:,$max-aperture:,$max-child-depth:,$maximum-component-length:,$md5:,$md5sum-md5:,$md5sum-pass:,$media-created:,$metering-mode:,$mood:,$name:,$name-frequency:,$note-count:,$offline-availability:,$offline-status:,$online:,$opened-by:,$orientation:,$original-filename:,$out-of-date:,$owner:,$page-count:,$paragraph-count:,$parental-rating:,$parental-rating-reason:,$parent-file-id:,$parent-name:,$parent-path:,$parse-full-path:,$parse-name:,$part-of-a-compilation:,$part-of-set:,$path:,$path-length:,$people:,$perceived-type:,$period:,$photometric-interpretation:,$physical-bytes-per-sector-for-atomicity:,$physical-bytes-per-sector-for-performance:,$plain-text-line-count:,$presentation-format:,$producer:,$product-name:,$product-version:,$promotion-url:,$protected:,$publisher:,$randomize:,$rating:,$referrer-url:,$regular-expression-match-0:,$regular-expression-match-1:,$regular-expression-match-2:,$regular-expression-match-3:,$regular-expression-match-4:,$regular-expression-match-5:,$regular-expression-match-6:,$regular-expression-match-7:,$regular-expression-match-8:,$regular-expression-match-9:,$regular-expression-matches-1-9:,$related-sound-file:,$remote-protocol:,$remote-protocol-flags:,$remote-protocol-version:,$reparse-tag:,$reparse-target:,$resolution-unit:,$revision-number:,$root-name:,$row:,$run-count:,$saturation:,$scale:,$sector-size:,$sfv-crc-32:,$sfv-pass:,$sha-1:,$sha1sum-pass:,$sha1sum-sha-1:,$sha-256:,$sha256sum-pass:,$sha256sum-sha-256:,$sha-384:,$sha-512:,$sha512sum-pass:,$sha512sum-sha-512:,$shared-with:,$sharpness:,$shell-attributes:,$shortcut-target:,$short-full-path:,$short-name:,$shutter-speed:,$sibling-count:,$sibling-file-count:,$sibling-folder-count:,$size:,$size-frequency:,$size-on-disk:,$slide-count:,$software:,$stem:,$stem-length:,$subject:,$subject-distance:,$subtitle:,$tags:,$template:,$thumbnail:,$time-accessed:,$time-created:,$time-modified:,$title:,$to:,$total-alternate-data-stream-size:,$total-alternate-data-stream-size-on-disk:,$total-bit-rate:,$total-disk-size:,$total-editing-time:,$total-size:,$total-size-on-disk:,$track:,$trademarks:,$transcoded-for-sync:,$type:,$url:,$used-disk-size:,$valid-utf-8:,$version:,$version-number:,$vertical-resolution:,$video-bit-rate:,$video-format:,$volume-label:,$volume-name:,$volume-path:,$volume-serial-number:,$white-balance:,$width:,$word-count:,$writer:,$year:,$zone-id:),",")

This would give you complete control over what properties to show.
This will also show just how incredibly slow it is to gather/calculate all property values.

Column Formulas



It's also possible to search Column 1 with column1:
For example, column1:"my property search"



A list of all the Everything properties:

Code: Select all

$35mm-Focal-Length:
$Album:
$Album-Artist:
$Alignment-Requirement:
$Allocation-Size:
$Alternate-Data-Stream-ANSI:
$Alternate-Data-Stream-Count:
$Alternate-Data-Stream-Hex:
$Alternate-Data-Stream-Names:
$Alternate-Data-Stream-Text/Plain:
$Alternate-Data-Stream-UTF-16:
$Alternate-Data-Stream-UTF-16BE:
$Alternate-Data-Stream-UTF-8:
$Altitude:
$Aperture:
$Artist:
$Aspect-Ratio:
$Attributes:
$Audio-Bit-Rate:
$Audio-Bits-Per-Sample:
$Audio-Channels:
$Audio-Format:
$Audio-Sample-Rate:
$Authors:
$Author-URL:
$Available-Free-Disk-Size:
$Beats-Per-Minute:
$Binary-Type:
$Bit-Depth:
$Brightness:
$Byte-Offset-For-Partition-Alignment:
$Byte-Offset-For-Sector-Alignment:
$Byte-Order-Mark:
$Camera-Maker:
$Camera-Model:
$Camera-Serial-Number:
$Case-Sensitive-Dir:
$Category:
$Character-Count:
$Character-Encoding:
$Child-Count:
$Child-Count-From-Disk:
$Child-File-Count:
$Child-File-Count-From-Disk:
$Child-Folder-Count:
$Child-Folder-Count-From-Disk:
$Child-Occurrence-Count:
$Child-Size:
$Cluster-Size:
$Color-Representation:
$Column-0:
$Column-1:
$Column-2:
$Column-3:
$Column-4:
$Column-5:
$Column-6:
$Column-7:
$Column-8:
$Column-9:
$Column-A:
$Column-B:
$Column-C:
$Column-D:
$Column-E:
$Column-F:
$Comment:
$Company:
$Composer:
$Compressed-Bits-Per-Pixel:
$Compressed-Size:
$Compression:
$Compression-Chunk-Shift:
$Compression-Cluster-Shift:
$Compression-Format:
$Compression-Ratio:
$Compression-Unit-Shift:
$Computer:
$Conductor:
$Container-File-Count:
$Container-Filenames:
$Content:
$Content-Created:
$Content-Provider:
$Content-Status:
$Content-Type:
$Contrast:
$Copyright:
$CRC-32:
$CRC-64:
$Custom-Property-0:
$Custom-Property-1:
$Custom-Property-2:
$Custom-Property-3:
$Custom-Property-4:
$Custom-Property-5:
$Custom-Property-6:
$Custom-Property-7:
$Custom-Property-8:
$Custom-Property-9:
$Date-Accessed:
$Date-Acquired:
$Date-Changed:
$Date-Created:
$Date-Indexed:
$Date-Modified:
$Date-Printed:
$Date-Received:
$Date-Recently-Changed:
$Date-Released:
$Date-Run:
$Date-Saved:
$Date-Sent:
$Date-Taken:
$Day-Accessed:
$Day-Created:
$Day-Modified:
$Delete-Pending:
$Descendant-Count:
$Descendant-File-Count:
$Descendant-Folder-Count:
$Description:
$Digital-Zoom:
$Dimensions:
$Director:
$Display-Full-Path:
$Display-Name:
$Document-Content-Type:
$Drive-Type:
$Effective-Physical-Bytes-Per-Sector-For-Atomicity:
$Encoded-By:
$Encryption-Status:
$End-Of-File:
$Exif-Version:
$Exposure-Bias:
$Exposure-Program:
$Exposure-Time:
$Extension:
$Extension-Frequency:
$Extension-Length:
$File-ID:
$File-List-Filename:
$File-List-Full-Path:
$Filename-Length:
$Filename-UTF-8-Byte-Length:
$File-Signature:
$File-Storage-Info-Flags:
$File-System:
$File-System-Flags:
$First-128-Bytes:
$First-16-Bytes:
$First-256-Bytes:
$First-2-Bytes:
$First-32-Bytes:
$First-4-Bytes:
$First-512-Bytes:
$First-64-Bytes:
$First-8-Bytes:
$First-Byte:
$Flash-Energy:
$Flash-Maker:
$Flash-Mode:
$Flash-Model:
$Focal-Length:
$Folder-Depth:
$Frame-Count:
$Frame-Rate:
$Free-Disk-Size:
$From:
$F-Stop:
$Full-Path:
$Full-Path-Length:
$Full-Path-UTF-8-Byte-Length:
$Genre:
$Group-Description:
$Hard-Link-Count:
$Hard-Link-Filenames:
$Height:
$Hidden-Slide-Count:
$Horizontal-Resolution:
$Host-URL:
$Icon:
$Image-ID:
$Incur-Seek-Penalty:
$Index-Number:
$Index-Type:
$Index-Volume-Label:
$Initial-Key:
$Is-Directory:
$Is-Folder:
$ISO-Speed:
$Kind:
$Language:
$Last-128-Bytes:
$Last-16-Bytes:
$Last-256-Bytes:
$Last-2-Bytes:
$Last-32-Bytes:
$Last-4-Bytes:
$Last-512-Bytes:
$Last-64-Bytes:
$Last-8-Bytes:
$Last-Author:
$Last-Byte:
$Latitude:
$Length:
$Lens-Maker:
$Lens-Model:
$Light-Source:
$Line-Count:
$Links-Dirty:
$Logical-Bytes-Per-Sector:
$Longitude:
$Machine-Target:
$Maker-Note:
$Manager:
$Max-Aperture:
$Max-Child-Depth:
$Maximum-Component-Length:
$MD5:
$md5sum-MD5:
$md5sum-Pass:
$Media-Created:
$Metering-Mode:
$Mood:
$Name:
$Name-Frequency:
$Note-Count:
$Offline-Availability:
$Offline-Status:
$Online:
$Opened-By:
$Orientation:
$Original-Filename:
$Out-of-Date:
$Owner:
$Page-Count:
$Paragraph-Count:
$Parental-Rating:
$Parental-Rating-Reason:
$Parent-File-ID:
$Parent-Name:
$Parent-Path:
$Parse-Full-Path:
$Parse-Name:
$Part-of-a-Compilation:
$Part-of-Set:
$Path:
$Path-Length:
$People:
$Perceived-Type:
$Period:
$Photometric-Interpretation:
$Physical-Bytes-Per-Sector-For-Atomicity:
$Physical-Bytes-Per-Sector-For-Performance:
$Plain-Text-Line-Count:
$Presentation-Format:
$Producer:
$Product-Name:
$Product-Version:
$Promotion-URL:
$Protected:
$Publisher:
$Randomize:
$Rating:
$Referrer-URL:
$Regular-Expression-Match-0:
$Regular-Expression-Match-1:
$Regular-Expression-Match-2:
$Regular-Expression-Match-3:
$Regular-Expression-Match-4:
$Regular-Expression-Match-5:
$Regular-Expression-Match-6:
$Regular-Expression-Match-7:
$Regular-Expression-Match-8:
$Regular-Expression-Match-9:
$Regular-Expression-Matches-1-9:
$Related-Sound-File:
$Remote-Protocol:
$Remote-Protocol-Flags:
$Remote-Protocol-Version:
$Reparse-Tag:
$Reparse-Target:
$Resolution-Unit:
$Revision-Number:
$Root-Name:
$Row:
$Run-Count:
$Saturation:
$Scale:
$Sector-Size:
$SFV-CRC-32:
$SFV-Pass:
$SHA-1:
$sha1sum-Pass:
$sha1sum-SHA-1:
$SHA-256:
$sha256sum-Pass:
$sha256sum-SHA-256:
$SHA-384:
$SHA-512:
$sha512sum-Pass:
$sha512sum-SHA-512:
$Shared-With:
$Sharpness:
$Shell-Attributes:
$Shortcut-Target:
$Short-Full-Path:
$Short-Name:
$Shutter-Speed:
$Sibling-Count:
$Sibling-File-Count:
$Sibling-Folder-Count:
$Size:
$Size-Frequency:
$Size-on-Disk:
$Slide-Count:
$Software:
$Stem:
$Stem-Length:
$Subject:
$Subject-Distance:
$Subtitle:
$Tags:
$Template:
$Thumbnail:
$Time-Accessed:
$Time-Created:
$Time-Modified:
$Title:
$To:
$Total-Alternate-Data-Stream-Size:
$Total-Alternate-Data-Stream-Size-On-Disk:
$Total-Bit-Rate:
$Total-Disk-Size:
$Total-Editing-Time:
$Total-Size:
$Total-Size-On-Disk:
$Track:
$Trademarks:
$Transcoded-For-Sync:
$Type:
$URL:
$Used-Disk-Size:
$Valid-UTF-8:
$Version:
$Version-Number:
$Vertical-Resolution:
$Video-Bit-Rate:
$Video-Format:
$Volume-Label:
$Volume-Name:
$Volume-Path:
$Volume-Serial-Number:
$White-Balance:
$Width:
$Word-Count:
$Writer:
$Year:
$Zone-ID:

(I recommend browsing result list column header -> Add Columns to pick your properties by category)

[raccoon]

A list of all the Everything properties:

Can you provide me a list of all properties, and their data origin types and combinations?

Eg, the Version property is probably a combination of a lot of things, including pdf_version and dll_version and exe_version. Some of them collected by windows, some collected by external iviewers, and others collected by proprietary parsing. Do you have such an atomized list?

[void]

Type
Metadata
File
Index
Content
Volume
Search

Category
Audio
Content
Document
Exif
File
ID3
Index
IPTC
Picture
Program
Search
Shortcut
Video
Volume
Vorbis
XMP
application/pdf
application/x-msdownload
application/x-ole-storage
application/zip
audio/flac
audio/midi
audio/mpeg
audio/ogg
audio/wav
audio/x-ape
image/bmp
image/gif
image/jpeg
image/png
image/tiff
image/vnd.adobe.photoshop
image/webp
image/x-icon
image/x-pcx
image/x-tga
text/plain
video/avi
video/mp4
video/x-flv
video/x-matroska

Type

Metadata

Code: Select all

35mm Focal Length
Album
Album Artist
Altitude
Aperture
Artist
Aspect Ratio
Audio Bit Rate
Audio Bits Per Sample
Audio Channels
Audio Format
Audio Sample Rate
Authors
Author URL
Beats Per Minute
Binary Type
Bit Depth
Brightness
Byte Order Mark
Camera Maker
Camera Model
Camera Serial Number
Category
Character Count
Color Representation
Comment
Company
Composer
Compressed Bits Per Pixel
Compression
Conductor
Container File Count
Container Filenames
Content Created
Content Provider
Content Status
Contrast
Copyright
Custom Property 0
Custom Property 1
Custom Property 2
Custom Property 3
Custom Property 4
Custom Property 5
Custom Property 6
Custom Property 7
Custom Property 8
Custom Property 9
Date Acquired
Date Printed
Date Received
Date Released
Date Saved
Date Sent
Date Taken
Description
Digital Zoom
Dimensions
Director
Document Content Type
Encoded By
Exif Version
Exposure Bias
Exposure Program
Exposure Time
File Signature
First 128 Bytes
First 16 Bytes
First 256 Bytes
First 2 Bytes
First 32 Bytes
First 4 Bytes
First 512 Bytes
First 64 Bytes
First 8 Bytes
First Byte
Flash Energy
Flash Maker
Flash Mode
Flash Model
Focal Length
Frame Count
Frame Rate
From
F-Stop
Genre
Group Description
Height
Hidden Slide Count
Horizontal Resolution
Image ID
Initial Key
ISO Speed
Language
Last 128 Bytes
Last 16 Bytes
Last 256 Bytes
Last 2 Bytes
Last 32 Bytes
Last 4 Bytes
Last 512 Bytes
Last 64 Bytes
Last 8 Bytes
Last Author
Last Byte
Latitude
Length
Lens Maker
Lens Model
Light Source
Line Count
Links Dirty
Longitude
Machine Target
Maker Note
Manager
Max Aperture
md5sum MD5
Media Created
Metering Mode
Mood
Note Count
Orientation
Original Filename
Page Count
Paragraph Count
Parental Rating
Parental Rating Reason
Part of a Compilation
Part of Set
People
Period
Photometric Interpretation
Presentation Format
Producer
Product Name
Product Version
Promotion URL
Protected
Publisher
Rating
Related Sound File
Resolution Unit
Revision Number
Saturation
Scale
SFV CRC-32
sha1sum SHA-1
sha256sum SHA-256
sha512sum SHA-512
Sharpness
Shortcut Target
Shutter Speed
Slide Count
Software
Subject
Subject Distance
Subtitle
Tags
Template
Title
To
Total Bit Rate
Total Editing Time
Track
Trademarks
Transcoded For Sync
URL
Version
Version Number
Vertical Resolution
Video Bit Rate
Video Format
White Balance
Width
Word Count
Writer
Year

File

Code: Select all

Allocation Size
Alternate Data Stream ANSI
Alternate Data Stream Count
Alternate Data Stream Hex
Alternate Data Stream Names
Alternate Data Stream Text/Plain
Alternate Data Stream UTF-16
Alternate Data Stream UTF-16BE
Alternate Data Stream UTF-8
Attributes
Case Sensitive Dir
Compressed Size
Compression Chunk Shift
Compression Cluster Shift
Compression Format
Compression Ratio
Compression Unit Shift
Computer
Content Type
Date Accessed
Date Changed
Date Created
Date Modified
Day Accessed
Day Created
Day Modified
Delete Pending
Display Full Path
Display Name
Encryption Status
End Of File
File ID
Hard Link Count
Hard Link Filenames
Host URL
Is Directory
Kind
Offline Availability
Offline Status
Opened By
Owner
Parse Full Path
Parse Name
Perceived Type
Referrer URL
Reparse Tag
Reparse Target
Shared With
Shell Attributes
Short Full Path
Short Name
Size
Size on Disk
Time Accessed
Time Created
Time Modified
Total Alternate Data Stream Size
Total Alternate Data Stream Size On Disk
Type
Zone ID

Index

Code: Select all

Child Count
Child File Count
Child Folder Count
Child Occurrence Count
Child Size
Date Indexed
Date Recently Changed
Date Run
Descendant Count
Descendant File Count
Descendant Folder Count
Extension
Extension Frequency
Extension Length
File List Filename
File List Full Path
Filename Length
Filename UTF-8 Byte Length
Folder Depth
Full Path
Full Path Length
Full Path UTF-8 Byte Length
Index Number
Index Type
Index Volume Label
Is Folder
Max Child Depth
Name
Name Frequency
Online
Out of Date
Parent File ID
Parent Name
Parent Path
Path
Path Length
Root Name
Row
Run Count
Sibling Count
Sibling File Count
Sibling Folder Count
Size Frequency
Stem
Stem Length

Content

Code: Select all

Character Encoding
Child Count From Disk
Child File Count From Disk
Child Folder Count From Disk
CRC-32
CRC-64
MD5
md5sum Pass
Plain Text Line Count
SFV Pass
SHA-1
sha1sum Pass
SHA-256
sha256sum Pass
SHA-384
SHA-512
sha512sum Pass
Total Size
Total Size On Disk
Valid UTF-8

Volume

Code: Select all

Alignment Requirement
Available Free Disk Size
Byte Offset For Partition Alignment
Byte Offset For Sector Alignment
Cluster Size
Drive Type
Effective Physical Bytes Per Sector For Atomicity
File Storage Info Flags
File System
File System Flags
Free Disk Size
Incur Seek Penalty
Logical Bytes Per Sector
Maximum Component Length
Physical Bytes Per Sector For Atomicity
Physical Bytes Per Sector For Performance
Remote Protocol
Remote Protocol Flags
Remote Protocol Version
Sector Size
Total Disk Size
Used Disk Size
Volume Label
Volume Name
Volume Path
Volume Serial Number

Search

Code: Select all

Column 0
Column 1
Column 2
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8
Column 9
Column A
Column B
Column C
Column D
Column E
Column F
Regular Expression Match 0
Regular Expression Match 1
Regular Expression Match 2
Regular Expression Match 3
Regular Expression Match 4
Regular Expression Match 5
Regular Expression Match 6
Regular Expression Match 7
Regular Expression Match 8
Regular Expression Match 9
Regular Expression Matches 1-9

Category

Audio

Code: Select all

Audio Sample Rate
Audio Channels
Audio Bits Per Sample
Audio Bit Rate
Audio Format
Parental Rating
Parental Rating Reason
Composer
Conductor
Group Description
Period
Mood
Part of Set
Initial Key
Beats Per Minute
Protected
Part of a Compilation
Title
Subtitle
Rating
Tags
Comment
Artist
Album Artist
Album
Year
Date Released
Track
Genre
Producer
Publisher
Content Provider
Media Created
Encoded By
Author URL
Promotion URL
Copyright

Content

Code: Select all

File Signature
CRC-32
CRC-64
MD5
SHA-1
SHA-256
Plain Text Line Count
SHA-384
SHA-512
Valid UTF-8
First Byte
First 2 Bytes
First 4 Bytes
First 8 Bytes
First 16 Bytes
First 32 Bytes
First 64 Bytes
First 128 Bytes
First 256 Bytes
First 512 Bytes
Last Byte
Last 2 Bytes
Last 4 Bytes
Last 8 Bytes
Last 16 Bytes
Last 32 Bytes
Last 64 Bytes
Last 128 Bytes
Last 256 Bytes
Last 512 Bytes
Byte Order Mark
SFV CRC-32
md5sum MD5
sha1sum SHA-1
sha256sum SHA-256
sha512sum SHA-512
SFV Pass
md5sum Pass
sha1sum Pass
sha256sum Pass
sha512sum Pass
Content Type
Perceived Type

Document

Code: Select all

Content Status
Document Content Type
Page Count
Word Count
Character Count
Line Count
Paragraph Count
Slide Count
Note Count
Hidden Slide Count
Presentation Format
Template
Scale
Links Dirty
Language
Title
Subject
Tags
Category
Comment
Authors
Last Author
Revision Number
Version Number
Software
Company
Manager
Content Created
Date Saved
Date Printed
Total Editing Time

Exif

Code: Select all

Software
Authors
Comment
Copyright
Tags
Rating
Subject
Title
Longitude
Latitude
Altitude
Color Representation
Compressed Bits Per Pixel
Compression
Horizontal Resolution
Image ID
Resolution Unit
Vertical Resolution
Aperture
Brightness
Camera Maker
Camera Model
Contrast
Date Taken
Digital Zoom
Exif Version
Exposure Bias
Exposure Time
Flash Mode
Flash Energy
F-Stop
Focal Length
35mm Focal Length
ISO Speed
Light Source
Maker Note
Description
Lens Maker
Lens Model
Camera Serial Number
Max Aperture
Metering Mode
Orientation
Photometric Interpretation
Exposure Program
Related Sound File
Saturation
Sharpness
Shutter Speed
Subject Distance
Transcoded For Sync
White Balance

File

Code: Select all

Name
Path
Size
Extension
Type
Date Modified
Date Created
Date Accessed
Attributes
Run Count
Size on Disk
Kind
Offline Availability
Offline Status
Shared With
Owner
Computer
Display Name
File ID
Parent File ID
Hard Link Count
Hard Link Filenames
Alternate Data Stream Count
Alternate Data Stream Names
Child Count From Disk
Child Folder Count From Disk
Child File Count From Disk
Allocation Size
Date Changed
Time Modified
Time Created
Time Accessed
Day Modified
Day Created
Day Accessed
Delete Pending
Is Directory
Case Sensitive Dir
Total Alternate Data Stream Size
Total Alternate Data Stream Size On Disk
Compressed Size
Compression Format
Compression Unit Shift
Compression Chunk Shift
Compression Cluster Shift
Compression Ratio
Reparse Tag
Reparse Target
End Of File
Short Name
Short Full Path
Encryption Status
Alternate Data Stream ANSI
Alternate Data Stream UTF-8
Alternate Data Stream UTF-16
Alternate Data Stream UTF-16BE
Alternate Data Stream Text/Plain
Alternate Data Stream Hex
Zone ID
Referrer URL
Host URL
Character Encoding

ID3

Code: Select all

Title
Artist
Album
Year
Comment
Track
Genre

Index

Code: Select all

Full Path
Stem
Parent Name
Parent Path
Root Name
Row
File List Filename
Filename Length
Full Path Length
Parent File ID
Date Recently Changed
Date Run
Folder Depth
Child Count
Child Folder Count
Child File Count
Sibling Count
Sibling Folder Count
Sibling File Count
Index Type
Index Volume Label
Online
Date Indexed
Out of Date
Name
Path
Extension
Date Recently Changed
Run Count
Date Run
Filename UTF-8 Byte Length
Full Path UTF-8 Byte Length
File List Full Path
Name Frequency
Size Frequency
Extension Frequency
Descendant Count
Descendant Folder Count
Descendant File Count
Max Child Depth
Stem Length
Extension Length
Path Length
Is Folder

IPTC

Code: Select all

Software
Authors
Copyright
Tags
Title
Description
Date Taken

Picture

Code: Select all

Width
Height
Dimensions
Aspect Ratio
Bit Depth
Frame Count
Lens Maker
Lens Model
Flash Maker
Flash Model
Camera Serial Number
Contrast
Brightness
Light Source
Exposure Program
Saturation
Sharpness
White Balance
Photometric Interpretation
Digital Zoom
Exif Version
Camera Maker
Camera Model
F-Stop
Exposure Time
ISO Speed
Exposure Bias
Focal Length
Max Aperture
Aperture
Metering Mode
Subject Distance
Flash Mode
Flash Energy
35mm Focal Length
Title
Subject
Rating
Tags
People
Comment
Latitude
Longitude
Altitude
Image ID
Horizontal Resolution
Vertical Resolution
Compression
Resolution Unit
Color Representation
Compressed Bits Per Pixel
Authors
Date Taken
Software
Date Acquired
Copyright
Maker Note
Media Created

Program

Code: Select all

Title
Subject
Description
Version
Product Name
Product Version
Company
Copyright
Category
Tags
Comment
Language
Trademarks
Original Filename
Binary Type
Machine Target
Authors
Revision Number
Content Created
Software

Search

Code: Select all

Regular Expression Match 0
Regular Expression Match 1
Regular Expression Match 2
Regular Expression Match 3
Regular Expression Match 4
Regular Expression Match 5
Regular Expression Match 6
Regular Expression Match 7
Regular Expression Match 8
Regular Expression Match 9
Regular Expression Matches 1-9
Column 0
Column 1
Column 2
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8
Column 9
Column A
Column B
Column C
Column D
Column E
Column F

Shortcut

Code: Select all

Shortcut Target
URL

Video

Code: Select all

Length
Width
Height
Dimensions
Aspect Ratio
Frame Rate
Video Bit Rate
Video Format
Total Bit Rate
Audio Sample Rate
Audio Channels
Audio Bits Per Sample
Audio Bit Rate
Audio Format
Parental Rating
Parental Rating Reason
Composer
Conductor
Period
Mood
Part of Set
Initial Key
Beats Per Minute
Protected
Title
Subtitle
Rating
Tags
Comment
Artist
Year
Genre
Director
Producer
Writer
Publisher
Content Provider
Media Created
Encoded By
Author URL
Promotion URL
Copyright

Volume

Code: Select all

Remote Protocol
Remote Protocol Version
Remote Protocol Flags
Logical Bytes Per Sector
Physical Bytes Per Sector For Atomicity
Physical Bytes Per Sector For Performance
Effective Physical Bytes Per Sector For Atomicity
File Storage Info Flags
Byte Offset For Sector Alignment
Byte Offset For Partition Alignment
Alignment Requirement
Volume Serial Number
Cluster Size
Sector Size
Available Free Disk Size
Used Disk Size
Free Disk Size
Total Disk Size
Volume Path
Volume Name
Volume Label
Maximum Component Length
File System Flags
File System
Drive Type
Incur Seek Penalty

Vorbis

Code: Select all

Title
Track
Year
Artist
Album
Comment
Genre
Date Released

XMP

Code: Select all

Software
Authors
Comment
Copyright
Date Acquired
Tags
Rating
Title
Description
Longitude
Latitude
Altitude
Color Representation
Compressed Bits Per Pixel
Compression
Horizontal Resolution
Image ID
Resolution Unit
Vertical Resolution
Aperture
Brightness
Camera Maker
Camera Model
Camera Serial Number
Contrast
Date Taken
Digital Zoom
Exif Version
Exposure Bias
Exposure Time
Flash Mode
Flash Energy
Flash Maker
Flash Model
F-Stop
Focal Length
35mm Focal Length
ISO Speed
Lens Maker
Lens Model
Light Source
Max Aperture
Metering Mode
Orientation
People
Photometric Interpretation
Exposure Program
Related Sound File
Saturation
Sharpness
Shutter Speed
Subject Distance
Transcoded For Sync
White Balance

application/pdf

Code: Select all

File Signature
Title
Authors
Software
Producer
Subject
Tags
Page Count
Version

application/x-msdownload

Code: Select all

File Signature
Machine Target

application/x-ole-storage

Code: Select all

File Signature
Machine Target
File Signature
Product Name
Product Version
Company

application/zip

Code: Select all

File Signature
Container Filenames
Container File Count

audio/flac

Code: Select all

Length
Total Bit Rate
Audio Bit Rate
Audio Sample Rate
Audio Channels
Audio Bits Per Sample
File Signature
Audio Format
Title
Track
Year
Artist
Album
Comment
Genre
Date Released

audio/midi

Code: Select all

File Signature
Comment
Title
Copyright
Length
Total Bit Rate

audio/mpeg

Code: Select all

File Signature
Length
Total Bit Rate
Audio Channels
Audio Sample Rate
Audio Bit Rate
Audio Format

audio/ogg

Code: Select all

File Signature
Audio Channels
Audio Sample Rate
Length
Total Bit Rate
Audio Bit Rate
Audio Format

audio/wav

Code: Select all

File Signature
Audio Channels
Audio Sample Rate
Audio Bits Per Sample
Audio Format
Length
Total Bit Rate
Audio Bit Rate

audio/x-ape

Code: Select all

Audio Format
File Signature
Length
Total Bit Rate
Audio Bit Rate
Audio Sample Rate
Audio Channels
Audio Bits Per Sample

image/bmp

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

image/gif

Code: Select all

Dimensions
Width
Height
Bit Depth
File Signature
Frame Count

image/jpeg

Code: Select all

File Signature
Dimensions
Width
Height
Bit Depth
Frame Count
Title
Copyright
Subject
Lens Maker
Lens Model
Camera Serial Number
Comment
Tags
Authors

image/png

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
Software
Comment
Title
Authors
Description
Copyright
Media Created
File Signature

image/tiff

Code: Select all

File Signature
Frame Count
Dimensions
Width
Height
Bit Depth
Title
Comment
Authors
Tags
Subject
Lens Maker
Lens Model
Camera Serial Number

image/vnd.adobe.photoshop

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

image/webp

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

image/x-icon

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

image/x-pcx

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

image/x-tga

Code: Select all

Dimensions
Width
Height
Bit Depth
Frame Count
File Signature

text/plain

Code: Select all

Valid UTF-8
Byte Order Mark
Plain Text Line Count

video/avi

Code: Select all

File Signature
Width
Height
Dimensions
Frame Count
Frame Rate
Length
Total Bit Rate
Video Format
Bit Depth
Audio Format
Audio Sample Rate
Audio Bits Per Sample
Audio Bit Rate
Video Bit Rate
Audio Channels
Video Bit Rate

video/mp4

Code: Select all

File Signature
Length
Total Bit Rate
Video Format
Video Bit Rate
Frame Rate
Width
Height
Dimensions
Audio Format
Audio Channels
Audio Sample Rate
Audio Bits Per Sample
Audio Bit Rate
Video Bit Rate
Frame Rate
Media Created

video/x-flv

Code: Select all

File Signature
Length
Total Bit Rate
Width
Height
Frame Rate
Video Bit Rate
Audio Sample Rate
Audio Bits Per Sample
Audio Channels
Dimensions

video/x-matroska

Code: Select all

File Signature
Length
Total Bit Rate
Video Format
Audio Format
Frame Rate
Width
Dimensions
Height
Dimensions
Audio Channels
Audio Sample Rate
Audio Bits Per Sample
Video Format
Audio Format
Media Created

If Everything cannot gather a property it will fall back to the system.
Convert spaces to - if you want to specify these properties with column formulas.

[klark1kent]

Thanks for the detailed and very helpful responses. I can't wait to play around with this.

Sidenote: in all fairness, I did experiment with the strings you provided, you're right, it moves at a crawl.

I'll probably use the column formulas though and continue experimenting with more targeted approach, i.e. identify the scope of the project and aggregate the property values for just the fields within a category such as images, or music files. Maybe that'll help me accomplish what I was looking for.

Either way - thanks for all the information, it's a huge help