Hi. I Need to access past 6 months of session duration data by room names. Is this possible via the Analytics API on Scale plan?

You need scale plan before you can use the analytics API. On that plan the start date must be within the past 7 days. You should download and store the data if you need it for a longer period of time. https://docs.livekit.io/deploy/admin/analytics-api/#start