Tranquilizer Bolt

You shot a magical bolt of slumber at a creature within range. Make a ranged attack against it. On a hit, the target becomes drowsy and is poisoned for the duration. Additionally, roll 6d12, the total is how many points of a creature this spell can affect. The target must succeed on a Constitution saving throw. On a failure, if the target falls to fewer hit points than the result, it falls unconscious instantly for the duration. On a success, if the creature falls unconscious if it falls to fewer hit points than half the result for the duration. The target wakes up, if it takes damage or someone within 5 feet of it takes an action to wake it.

this spell won't affect those who are immune to magical sleep.

At Higher Levels. You create one additional bolt for each spell slot above 4, which you can shoot at different targets, or the same target. Make a new ranged spell attack for each bolt. If you hit the same target with multiple bolts, add the total of how many hit points are affected together. For example, if you hit a creature with two bolts, the total is 12d12.