File last accessed report

[TheRealStriff]

This would be great as trying to audit all files in our SharePoint sites.
Either all sites, or list of sites via CSV, via last accessed date.

I've got a script doing this, can set a variable to look for files not last access (not last modified) in the last XXX amount of years.
From this it's used (or will be) to archive off these files.

Having this in NovaPoint would be great.

Happy share my script, the output etc.

[Barbarur]

I guess the script uses a CAML query, right?
Yeah, share the script with me. I'll have a look for implementation.

[TheRealStriff]

Yep uses CAML query!...

I had an issue with it, hitting 5000 item limit, and could not work around it, so when it hit this, would then split into chunking going back to a predefined date

Also because in our environment our session authentication last for 7 hours, I have it to pause and prompt to re-authenticate.
Which all your scripts do, so that has been great.

SPO-Last Accessed.txt

Script attached.
Thanks

[TheRealStriff]

I'm testing a new script. as the above one, although it seemed to work, I was still getting throttling from it.

This one, so far seems to avoid this.
(also playing around with icons in the output terminal :) )

Unused Files audit_SPO.txt

[Barbarur]

Hi @TheRealStriff ,

Please try the filters on the last release 0.14.5

[tm16woke]

Just wanted to ask if it is possible for the output file size on the report is in KB instead of MB?

[Barbarur]

I can see to add it. Though I'm wondering, what is the need to that small number? Currently the report goes down to 0.01Mb which is already pretty small, I usually see people focus on large size files.