We consider truncations of half-maximal and maximal supergravity theories in four dimensions and we analyse the landscape of vacua for those embedding tensor configurations having a string theory origin in terms of geometric flux compactifications. The full dictionary between fluxes and embedding tensor components is worked out, the gaugings are identified and the full mass spectra are computed. The search of vacua is carried out by applying algebraic geometry techniques which allows for complete analytical treatment. We furthermore discuss the arising of non-supersymmetric and nevertheless stable solutions.