mirror of https://github.com/kacos2000/Queries
You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
498 B
MySQL
17 lines
498 B
MySQL
2 years ago
|
-- This query is to show the content of the SystemIndex_1_PropertyStore table
|
||
|
-- of the new Windows.db (Win 11 search database)
|
||
|
--
|
||
|
-- Database location:
|
||
|
-- C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.db
|
||
|
|
||
|
SELECT
|
||
|
WorkId,
|
||
|
ColumnId,
|
||
|
-- Since the field is a BLOB, this will show either text of the hex value:
|
||
|
case
|
||
|
when typeof(value) is 'text' or typeof(value) is 'integer'
|
||
|
then cast(value as 'text')
|
||
|
else hex(Value)
|
||
|
end as 'Value'
|
||
|
|
||
|
from SystemIndex_1_PropertyStore
|