It’s still sleeping
Hogwarts Legacy has a lot of lore-related nods buried in its many field guide collectibles, including the Sleeping Dragon Statue. Here’s where to find it, so you can make some more field guide progress.
The Sleeping Dragon Statue is in Hogwarts, below the Bell Tower Courtyard Floo Flame
Go to the Bell Tower Courtyard Floo Flame and zone in.
Walk up the stairway leading back into Hogwarts (pictured), and go through the door in front of you. Immediately hang a left and go down those stairs. Keep following the stairway downward, and you’ll find the Sleeping Dragon Statue in plain view in an alcove. That’s it! All you really need to focus on to get there is the Bell Tower Courtyard Floo Flame.
Like other points of interest that have a field guide page at them, you’ll need to cast Revelio for the page to appear. Grab it, and you’ll be finished with the Sleeping Dragon for good.
This basement area also has a level II lock that leads to a wand cosmetic (for the collection), and a classroom that has another field guide page (a Muggle artifact). To get there, just turn around when facing the Sleeping Dragon Statue, and continue down the hallway. The classroom is on the left, and the locked door is straight ahead.