Setup

This is a DataviewJS query to find files that do not exist and count how often you link to each of these files.

Code

Don’t forget to start and end the code block with three backticks.

dataviewjs
dv.paragraph("## Uncreated Notes with Mentions Count");
 
let links = dv.app.metadataCache.unresolvedLinks;
let data = [];
 
for (let file in links) {
    for (let unresolved in links[file]) {
        data.push({ 
            note: unresolved, 
            mentions: links[file][unresolved] 
        });
    }
}
 
let groupedData = data.reduce((acc, curr) => {
    let found = acc.find(item => item.note === curr.note);
    if (found) {
        found.mentions += curr.mentions;
    } else {
        acc.push(curr);
    }
    return acc;
}, []);
 
groupedData.sort((a, b) => b.mentions - a.mentions);
 
dv.table(["Uncreated Note", "Mentions"], groupedData.map(item => [item.note, item.mentions]));

Result

Table of 111 uncreated notes sorted by mention count, top entry linked 18 times